[Home] [Help]
PACKAGE BODY: APPS.CSI_MASS_EDIT_PUB_W
Source
1 package body csi_mass_edit_pub_w as
2 /* $Header: csipmewb.pls 120.5.12010000.3 2008/12/03 08:33:43 ngoutam 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_mass_edit_pub.mass_edit_tbl, a0 JTF_NUMBER_TABLE
26 , a1 JTF_VARCHAR2_TABLE_100
27 , a2 JTF_NUMBER_TABLE
28 , a3 JTF_NUMBER_TABLE
29 , a4 JTF_VARCHAR2_TABLE_100
30 , a5 JTF_VARCHAR2_TABLE_100
31 , a6 JTF_VARCHAR2_TABLE_2000
32 , a7 JTF_DATE_TABLE
33 , a8 JTF_DATE_TABLE
34 , a9 JTF_DATE_TABLE
35 , a10 JTF_NUMBER_TABLE
36 , a11 JTF_VARCHAR2_TABLE_100
37 ) as
38 ddindx binary_integer; indx binary_integer;
39 begin
40 if a0 is not null and a0.count > 0 then
41 if a0.count > 0 then
42 indx := a0.first;
43 ddindx := 1;
44 while true loop
45 t(ddindx).entry_id := rosetta_g_miss_num_map(a0(indx));
46 t(ddindx).name := a1(indx);
47 t(ddindx).txn_line_id := rosetta_g_miss_num_map(a2(indx));
48 t(ddindx).txn_line_detail_id := rosetta_g_miss_num_map(a3(indx));
49 t(ddindx).status_code := a4(indx);
50 t(ddindx).batch_type := a5(indx);
51 t(ddindx).description := a6(indx);
52 t(ddindx).schedule_date := rosetta_g_miss_date_in_map(a7(indx));
53 t(ddindx).start_date := rosetta_g_miss_date_in_map(a8(indx));
54 t(ddindx).end_date := rosetta_g_miss_date_in_map(a9(indx));
55 t(ddindx).object_version_number := rosetta_g_miss_num_map(a10(indx));
56 t(ddindx).system_cascade := a11(indx);
57 ddindx := ddindx+1;
58 if a0.last =indx
59 then exit;
60 end if;
61 indx := a0.next(indx);
62 end loop;
63 end if;
64 end if;
65 end rosetta_table_copy_in_p4;
66 procedure rosetta_table_copy_out_p4(t csi_mass_edit_pub.mass_edit_tbl, a0 out nocopy JTF_NUMBER_TABLE
67 , a1 out nocopy JTF_VARCHAR2_TABLE_100
68 , a2 out nocopy JTF_NUMBER_TABLE
69 , a3 out nocopy JTF_NUMBER_TABLE
70 , a4 out nocopy JTF_VARCHAR2_TABLE_100
71 , a5 out nocopy JTF_VARCHAR2_TABLE_100
72 , a6 out nocopy JTF_VARCHAR2_TABLE_2000
73 , a7 out nocopy JTF_DATE_TABLE
74 , a8 out nocopy JTF_DATE_TABLE
75 , a9 out nocopy JTF_DATE_TABLE
76 , a10 out nocopy JTF_NUMBER_TABLE
77 , a11 out nocopy JTF_VARCHAR2_TABLE_100
78 ) as
79 ddindx binary_integer; indx binary_integer;
80 begin
81 if t is null or t.count = 0 then
82 a0 := JTF_NUMBER_TABLE();
83 a1 := JTF_VARCHAR2_TABLE_100();
84 a2 := JTF_NUMBER_TABLE();
85 a3 := JTF_NUMBER_TABLE();
86 a4 := JTF_VARCHAR2_TABLE_100();
87 a5 := JTF_VARCHAR2_TABLE_100();
88 a6 := JTF_VARCHAR2_TABLE_2000();
89 a7 := JTF_DATE_TABLE();
90 a8 := JTF_DATE_TABLE();
91 a9 := JTF_DATE_TABLE();
92 a10 := JTF_NUMBER_TABLE();
93 a11 := JTF_VARCHAR2_TABLE_100();
94 else
95 a0 := JTF_NUMBER_TABLE();
96 a1 := JTF_VARCHAR2_TABLE_100();
97 a2 := JTF_NUMBER_TABLE();
98 a3 := JTF_NUMBER_TABLE();
99 a4 := JTF_VARCHAR2_TABLE_100();
100 a5 := JTF_VARCHAR2_TABLE_100();
101 a6 := JTF_VARCHAR2_TABLE_2000();
102 a7 := JTF_DATE_TABLE();
103 a8 := JTF_DATE_TABLE();
104 a9 := JTF_DATE_TABLE();
105 a10 := JTF_NUMBER_TABLE();
106 a11 := JTF_VARCHAR2_TABLE_100();
107 if t.count > 0 then
108 a0.extend(t.count);
109 a1.extend(t.count);
110 a2.extend(t.count);
111 a3.extend(t.count);
112 a4.extend(t.count);
113 a5.extend(t.count);
114 a6.extend(t.count);
115 a7.extend(t.count);
116 a8.extend(t.count);
117 a9.extend(t.count);
118 a10.extend(t.count);
119 a11.extend(t.count);
120 ddindx := t.first;
121 indx := 1;
122 while true loop
123 a0(indx) := rosetta_g_miss_num_map(t(ddindx).entry_id);
124 a1(indx) := t(ddindx).name;
125 a2(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_id);
126 a3(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_detail_id);
127 a4(indx) := t(ddindx).status_code;
128 a5(indx) := t(ddindx).batch_type;
129 a6(indx) := t(ddindx).description;
130 a7(indx) := t(ddindx).schedule_date;
131 a8(indx) := t(ddindx).start_date;
132 a9(indx) := t(ddindx).end_date;
133 a10(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
134 a11(indx) := t(ddindx).system_cascade;
135 indx := indx+1;
136 if t.last =ddindx
137 then exit;
138 end if;
139 ddindx := t.next(ddindx);
140 end loop;
141 end if;
142 end if;
143 end rosetta_table_copy_out_p4;
144
145 procedure rosetta_table_copy_in_p6(t out nocopy csi_mass_edit_pub.mass_edit_inst_tbl, a0 JTF_NUMBER_TABLE
146 , a1 JTF_NUMBER_TABLE
147 , a2 JTF_DATE_TABLE
148 , a3 JTF_NUMBER_TABLE
149 ) as
150 ddindx binary_integer; indx binary_integer;
151 begin
152 if a0 is not null and a0.count > 0 then
153 if a0.count > 0 then
154 indx := a0.first;
155 ddindx := 1;
156 while true loop
157 t(ddindx).txn_line_detail_id := rosetta_g_miss_num_map(a0(indx));
158 t(ddindx).instance_id := rosetta_g_miss_num_map(a1(indx));
159 t(ddindx).active_end_date := rosetta_g_miss_date_in_map(a2(indx));
160 t(ddindx).object_version_number := rosetta_g_miss_num_map(a3(indx));
161 ddindx := ddindx+1;
162 if a0.last =indx
163 then exit;
164 end if;
165 indx := a0.next(indx);
166 end loop;
167 end if;
168 end if;
169 end rosetta_table_copy_in_p6;
170 procedure rosetta_table_copy_out_p6(t csi_mass_edit_pub.mass_edit_inst_tbl, a0 out nocopy JTF_NUMBER_TABLE
171 , a1 out nocopy JTF_NUMBER_TABLE
172 , a2 out nocopy JTF_DATE_TABLE
173 , a3 out nocopy JTF_NUMBER_TABLE
174 ) as
175 ddindx binary_integer; indx binary_integer;
176 begin
177 if t is null or t.count = 0 then
178 a0 := JTF_NUMBER_TABLE();
179 a1 := JTF_NUMBER_TABLE();
180 a2 := JTF_DATE_TABLE();
181 a3 := JTF_NUMBER_TABLE();
182 else
183 a0 := JTF_NUMBER_TABLE();
184 a1 := JTF_NUMBER_TABLE();
185 a2 := JTF_DATE_TABLE();
186 a3 := JTF_NUMBER_TABLE();
187 if t.count > 0 then
188 a0.extend(t.count);
189 a1.extend(t.count);
190 a2.extend(t.count);
191 a3.extend(t.count);
192 ddindx := t.first;
193 indx := 1;
194 while true loop
195 a0(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_detail_id);
196 a1(indx) := rosetta_g_miss_num_map(t(ddindx).instance_id);
197 a2(indx) := t(ddindx).active_end_date;
198 a3(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
199 indx := indx+1;
200 if t.last =ddindx
201 then exit;
202 end if;
203 ddindx := t.next(ddindx);
204 end loop;
205 end if;
206 end if;
207 end rosetta_table_copy_out_p6;
208
209 procedure rosetta_table_copy_in_p8(t out nocopy csi_mass_edit_pub.mass_edit_error_tbl, a0 JTF_NUMBER_TABLE
210 , a1 JTF_NUMBER_TABLE
211 , a2 JTF_NUMBER_TABLE
212 , a3 JTF_VARCHAR2_TABLE_2000
213 , a4 JTF_VARCHAR2_TABLE_100
214 , a5 JTF_VARCHAR2_TABLE_100
215 ) as
216 ddindx binary_integer; indx binary_integer;
217 begin
218 if a0 is not null and a0.count > 0 then
219 if a0.count > 0 then
220 indx := a0.first;
221 ddindx := 1;
222 while true loop
223 t(ddindx).entry_id := rosetta_g_miss_num_map(a0(indx));
224 t(ddindx).txn_line_detail_id := rosetta_g_miss_num_map(a1(indx));
225 t(ddindx).instance_id := rosetta_g_miss_num_map(a2(indx));
226 t(ddindx).error_text := a3(indx);
227 t(ddindx).error_code := a4(indx);
228 t(ddindx).name := a5(indx);
229 ddindx := ddindx+1;
230 if a0.last =indx
231 then exit;
232 end if;
233 indx := a0.next(indx);
234 end loop;
235 end if;
236 end if;
237 end rosetta_table_copy_in_p8;
238 procedure rosetta_table_copy_out_p8(t csi_mass_edit_pub.mass_edit_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
239 , a1 out nocopy JTF_NUMBER_TABLE
240 , a2 out nocopy JTF_NUMBER_TABLE
241 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
242 , a4 out nocopy JTF_VARCHAR2_TABLE_100
243 , a5 out nocopy JTF_VARCHAR2_TABLE_100
244 ) as
245 ddindx binary_integer; indx binary_integer;
246 begin
247 if t is null or t.count = 0 then
248 a0 := JTF_NUMBER_TABLE();
249 a1 := JTF_NUMBER_TABLE();
250 a2 := JTF_NUMBER_TABLE();
251 a3 := JTF_VARCHAR2_TABLE_2000();
252 a4 := JTF_VARCHAR2_TABLE_100();
253 a5 := JTF_VARCHAR2_TABLE_100();
254 else
255 a0 := JTF_NUMBER_TABLE();
256 a1 := JTF_NUMBER_TABLE();
257 a2 := JTF_NUMBER_TABLE();
258 a3 := JTF_VARCHAR2_TABLE_2000();
259 a4 := JTF_VARCHAR2_TABLE_100();
260 a5 := JTF_VARCHAR2_TABLE_100();
261 if t.count > 0 then
262 a0.extend(t.count);
263 a1.extend(t.count);
264 a2.extend(t.count);
265 a3.extend(t.count);
266 a4.extend(t.count);
267 a5.extend(t.count);
268 ddindx := t.first;
269 indx := 1;
270 while true loop
271 a0(indx) := rosetta_g_miss_num_map(t(ddindx).entry_id);
272 a1(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_detail_id);
273 a2(indx) := rosetta_g_miss_num_map(t(ddindx).instance_id);
274 a3(indx) := t(ddindx).error_text;
275 a4(indx) := t(ddindx).error_code;
276 a5(indx) := t(ddindx).name;
277 indx := indx+1;
278 if t.last =ddindx
279 then exit;
280 end if;
281 ddindx := t.next(ddindx);
282 end loop;
283 end if;
284 end if;
285 end rosetta_table_copy_out_p8;
286
287 procedure rosetta_table_copy_in_p10(t out nocopy csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 JTF_NUMBER_TABLE
288 , a1 JTF_VARCHAR2_TABLE_100
289 , a2 JTF_NUMBER_TABLE
290 , a3 JTF_NUMBER_TABLE
291 , a4 JTF_VARCHAR2_TABLE_2000
292 , a5 JTF_VARCHAR2_TABLE_100
293 , a6 JTF_VARCHAR2_TABLE_100
294 ) as
295 ddindx binary_integer; indx binary_integer;
296 begin
297 if a0 is not null and a0.count > 0 then
298 if a0.count > 0 then
299 indx := a0.first;
300 ddindx := 1;
301 while true loop
302 t(ddindx).entry_id := rosetta_g_miss_num_map(a0(indx));
303 t(ddindx).batch_name := a1(indx);
304 t(ddindx).txn_line_detail_id := rosetta_g_miss_num_map(a2(indx));
305 t(ddindx).system_id := rosetta_g_miss_num_map(a3(indx));
306 t(ddindx).error_text := a4(indx);
307 t(ddindx).error_code := a5(indx);
308 t(ddindx).name := a6(indx);
309 ddindx := ddindx+1;
310 if a0.last =indx
311 then exit;
312 end if;
313 indx := a0.next(indx);
314 end loop;
315 end if;
316 end if;
317 end rosetta_table_copy_in_p10;
318 procedure rosetta_table_copy_out_p10(t csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
319 , a1 out nocopy JTF_VARCHAR2_TABLE_100
320 , a2 out nocopy JTF_NUMBER_TABLE
321 , a3 out nocopy JTF_NUMBER_TABLE
322 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
323 , a5 out nocopy JTF_VARCHAR2_TABLE_100
324 , a6 out nocopy JTF_VARCHAR2_TABLE_100
325 ) as
326 ddindx binary_integer; indx binary_integer;
327 begin
328 if t is null or t.count = 0 then
329 a0 := JTF_NUMBER_TABLE();
330 a1 := JTF_VARCHAR2_TABLE_100();
331 a2 := JTF_NUMBER_TABLE();
332 a3 := JTF_NUMBER_TABLE();
333 a4 := JTF_VARCHAR2_TABLE_2000();
334 a5 := JTF_VARCHAR2_TABLE_100();
335 a6 := JTF_VARCHAR2_TABLE_100();
336 else
337 a0 := JTF_NUMBER_TABLE();
338 a1 := JTF_VARCHAR2_TABLE_100();
339 a2 := JTF_NUMBER_TABLE();
340 a3 := JTF_NUMBER_TABLE();
341 a4 := JTF_VARCHAR2_TABLE_2000();
342 a5 := JTF_VARCHAR2_TABLE_100();
343 a6 := JTF_VARCHAR2_TABLE_100();
344 if t.count > 0 then
345 a0.extend(t.count);
346 a1.extend(t.count);
347 a2.extend(t.count);
348 a3.extend(t.count);
349 a4.extend(t.count);
350 a5.extend(t.count);
351 a6.extend(t.count);
352 ddindx := t.first;
353 indx := 1;
354 while true loop
355 a0(indx) := rosetta_g_miss_num_map(t(ddindx).entry_id);
356 a1(indx) := t(ddindx).batch_name;
357 a2(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_detail_id);
358 a3(indx) := rosetta_g_miss_num_map(t(ddindx).system_id);
359 a4(indx) := t(ddindx).error_text;
360 a5(indx) := t(ddindx).error_code;
361 a6(indx) := t(ddindx).name;
362 indx := indx+1;
363 if t.last =ddindx
364 then exit;
365 end if;
366 ddindx := t.next(ddindx);
367 end loop;
368 end if;
369 end if;
370 end rosetta_table_copy_out_p10;
371
372 procedure rosetta_table_copy_in_p12(t out nocopy csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 JTF_NUMBER_TABLE
373 , a1 JTF_VARCHAR2_TABLE_100
374 , a2 JTF_VARCHAR2_TABLE_2000
375 , a3 JTF_NUMBER_TABLE
376 , a4 JTF_NUMBER_TABLE
377 , a5 JTF_VARCHAR2_TABLE_100
378 , a6 JTF_VARCHAR2_TABLE_100
379 ) as
380 ddindx binary_integer; indx binary_integer;
381 begin
382 if a0 is not null and a0.count > 0 then
383 if a0.count > 0 then
384 indx := a0.first;
385 ddindx := 1;
386 while true loop
387 t(ddindx).instance_id := rosetta_g_miss_num_map(a0(indx));
388 t(ddindx).entity_name := a1(indx);
389 t(ddindx).error_message := a2(indx);
390 t(ddindx).entry_id := rosetta_g_miss_num_map(a3(indx));
391 t(ddindx).txn_line_detail_id := rosetta_g_miss_num_map(a4(indx));
392 t(ddindx).error_code := a5(indx);
393 t(ddindx).name := a6(indx);
394 ddindx := ddindx+1;
395 if a0.last =indx
396 then exit;
397 end if;
398 indx := a0.next(indx);
399 end loop;
400 end if;
401 end if;
402 end rosetta_table_copy_in_p12;
403 procedure rosetta_table_copy_out_p12(t csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
404 , a1 out nocopy JTF_VARCHAR2_TABLE_100
405 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
406 , a3 out nocopy JTF_NUMBER_TABLE
407 , a4 out nocopy JTF_NUMBER_TABLE
408 , a5 out nocopy JTF_VARCHAR2_TABLE_100
409 , a6 out nocopy JTF_VARCHAR2_TABLE_100
410 ) as
411 ddindx binary_integer; indx binary_integer;
412 begin
413 if t is null or t.count = 0 then
414 a0 := JTF_NUMBER_TABLE();
415 a1 := JTF_VARCHAR2_TABLE_100();
416 a2 := JTF_VARCHAR2_TABLE_2000();
417 a3 := JTF_NUMBER_TABLE();
418 a4 := JTF_NUMBER_TABLE();
419 a5 := JTF_VARCHAR2_TABLE_100();
420 a6 := JTF_VARCHAR2_TABLE_100();
421 else
422 a0 := JTF_NUMBER_TABLE();
423 a1 := JTF_VARCHAR2_TABLE_100();
424 a2 := JTF_VARCHAR2_TABLE_2000();
425 a3 := JTF_NUMBER_TABLE();
426 a4 := JTF_NUMBER_TABLE();
427 a5 := JTF_VARCHAR2_TABLE_100();
428 a6 := JTF_VARCHAR2_TABLE_100();
429 if t.count > 0 then
430 a0.extend(t.count);
431 a1.extend(t.count);
432 a2.extend(t.count);
433 a3.extend(t.count);
434 a4.extend(t.count);
435 a5.extend(t.count);
436 a6.extend(t.count);
437 ddindx := t.first;
438 indx := 1;
439 while true loop
440 a0(indx) := rosetta_g_miss_num_map(t(ddindx).instance_id);
441 a1(indx) := t(ddindx).entity_name;
442 a2(indx) := t(ddindx).error_message;
443 a3(indx) := rosetta_g_miss_num_map(t(ddindx).entry_id);
444 a4(indx) := rosetta_g_miss_num_map(t(ddindx).txn_line_detail_id);
445 a5(indx) := t(ddindx).error_code;
446 a6(indx) := t(ddindx).name;
447 indx := indx+1;
448 if t.last =ddindx
449 then exit;
450 end if;
451 ddindx := t.next(ddindx);
452 end loop;
453 end if;
454 end if;
455 end rosetta_table_copy_out_p12;
456
457 procedure create_mass_edit_batch(p_api_version NUMBER
458 , p_commit VARCHAR2
459 , p_init_msg_list VARCHAR2
460 , p_validation_level NUMBER
461 , p4_a0 in out nocopy NUMBER
462 , p4_a1 in out nocopy VARCHAR2
463 , p4_a2 in out nocopy NUMBER
464 , p4_a3 in out nocopy NUMBER
465 , p4_a4 in out nocopy VARCHAR2
466 , p4_a5 in out nocopy VARCHAR2
467 , p4_a6 in out nocopy VARCHAR2
468 , p4_a7 in out nocopy DATE
469 , p4_a8 in out nocopy DATE
470 , p4_a9 in out nocopy DATE
471 , p4_a10 in out nocopy NUMBER
472 , p4_a11 in out nocopy VARCHAR2
473 , p5_a0 in out nocopy NUMBER
474 , p5_a1 in out nocopy NUMBER
475 , p5_a2 in out nocopy NUMBER
476 , p5_a3 in out nocopy NUMBER
477 , p5_a4 in out nocopy VARCHAR2
478 , p5_a5 in out nocopy NUMBER
479 , p5_a6 in out nocopy NUMBER
480 , p5_a7 in out nocopy NUMBER
481 , p5_a8 in out nocopy VARCHAR2
482 , p5_a9 in out nocopy VARCHAR2
483 , p5_a10 in out nocopy VARCHAR2
484 , p5_a11 in out nocopy VARCHAR2
485 , p5_a12 in out nocopy VARCHAR2
486 , p5_a13 in out nocopy VARCHAR2
487 , p5_a14 in out nocopy VARCHAR2
488 , p5_a15 in out nocopy VARCHAR2
489 , p5_a16 in out nocopy VARCHAR2
490 , p5_a17 in out nocopy VARCHAR2
491 , p5_a18 in out nocopy VARCHAR2
492 , p5_a19 in out nocopy VARCHAR2
493 , p5_a20 in out nocopy VARCHAR2
494 , p5_a21 in out nocopy VARCHAR2
495 , p5_a22 in out nocopy VARCHAR2
496 , p5_a23 in out nocopy VARCHAR2
497 , p5_a24 in out nocopy VARCHAR2
498 , p5_a25 in out nocopy VARCHAR2
499 , p5_a26 in out nocopy VARCHAR2
500 , p5_a27 in out nocopy VARCHAR2
501 , p5_a28 in out nocopy VARCHAR2
502 , p5_a29 in out nocopy VARCHAR2
503 , p5_a30 in out nocopy VARCHAR2
504 , p5_a31 in out nocopy NUMBER
505 , p6_a0 in out nocopy JTF_NUMBER_TABLE
506 , p6_a1 in out nocopy JTF_NUMBER_TABLE
507 , p6_a2 in out nocopy JTF_DATE_TABLE
508 , p6_a3 in out nocopy JTF_NUMBER_TABLE
509 , p7_a0 in out nocopy NUMBER
510 , p7_a1 in out nocopy NUMBER
511 , p7_a2 in out nocopy NUMBER
512 , p7_a3 in out nocopy VARCHAR2
513 , p7_a4 in out nocopy VARCHAR2
514 , p7_a5 in out nocopy NUMBER
515 , p7_a6 in out nocopy NUMBER
516 , p7_a7 in out nocopy NUMBER
517 , p7_a8 in out nocopy NUMBER
518 , p7_a9 in out nocopy VARCHAR2
519 , p7_a10 in out nocopy NUMBER
520 , p7_a11 in out nocopy NUMBER
521 , p7_a12 in out nocopy VARCHAR2
522 , p7_a13 in out nocopy NUMBER
523 , p7_a14 in out nocopy VARCHAR2
524 , p7_a15 in out nocopy NUMBER
525 , p7_a16 in out nocopy VARCHAR2
526 , p7_a17 in out nocopy VARCHAR2
527 , p7_a18 in out nocopy VARCHAR2
528 , p7_a19 in out nocopy VARCHAR2
529 , p7_a20 in out nocopy NUMBER
530 , p7_a21 in out nocopy DATE
531 , p7_a22 in out nocopy DATE
532 , p7_a23 in out nocopy VARCHAR2
533 , p7_a24 in out nocopy NUMBER
534 , p7_a25 in out nocopy VARCHAR2
535 , p7_a26 in out nocopy VARCHAR2
536 , p7_a27 in out nocopy DATE
537 , p7_a28 in out nocopy DATE
538 , p7_a29 in out nocopy DATE
539 , p7_a30 in out nocopy VARCHAR2
540 , p7_a31 in out nocopy NUMBER
541 , p7_a32 in out nocopy NUMBER
542 , p7_a33 in out nocopy DATE
543 , p7_a34 in out nocopy NUMBER
544 , p7_a35 in out nocopy NUMBER
545 , p7_a36 in out nocopy NUMBER
546 , p7_a37 in out nocopy VARCHAR2
547 , p7_a38 in out nocopy VARCHAR2
548 , p7_a39 in out nocopy VARCHAR2
549 , p7_a40 in out nocopy NUMBER
550 , p7_a41 in out nocopy NUMBER
551 , p7_a42 in out nocopy NUMBER
552 , p7_a43 in out nocopy NUMBER
553 , p7_a44 in out nocopy NUMBER
554 , p7_a45 in out nocopy DATE
555 , p7_a46 in out nocopy VARCHAR2
556 , p7_a47 in out nocopy VARCHAR2
557 , p7_a48 in out nocopy VARCHAR2
558 , p7_a49 in out nocopy NUMBER
559 , p7_a50 in out nocopy VARCHAR2
560 , p7_a51 in out nocopy VARCHAR2
561 , p7_a52 in out nocopy VARCHAR2
562 , p7_a53 in out nocopy VARCHAR2
563 , p7_a54 in out nocopy VARCHAR2
564 , p7_a55 in out nocopy VARCHAR2
565 , p7_a56 in out nocopy VARCHAR2
566 , p7_a57 in out nocopy VARCHAR2
567 , p7_a58 in out nocopy VARCHAR2
568 , p7_a59 in out nocopy VARCHAR2
569 , p7_a60 in out nocopy VARCHAR2
570 , p7_a61 in out nocopy VARCHAR2
571 , p7_a62 in out nocopy VARCHAR2
572 , p7_a63 in out nocopy VARCHAR2
573 , p7_a64 in out nocopy VARCHAR2
574 , p7_a65 in out nocopy VARCHAR2
575 , p7_a66 in out nocopy VARCHAR2
576 , p7_a67 in out nocopy NUMBER
577 , p7_a68 in out nocopy NUMBER
578 , p7_a69 in out nocopy NUMBER
579 , p7_a70 in out nocopy NUMBER
580 , p7_a71 in out nocopy NUMBER
581 , p8_a0 in out nocopy JTF_NUMBER_TABLE
582 , p8_a1 in out nocopy JTF_NUMBER_TABLE
583 , p8_a2 in out nocopy JTF_NUMBER_TABLE
584 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
585 , p8_a4 in out nocopy JTF_NUMBER_TABLE
586 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
587 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
588 , p8_a7 in out nocopy JTF_NUMBER_TABLE
589 , p8_a8 in out nocopy JTF_DATE_TABLE
590 , p8_a9 in out nocopy JTF_DATE_TABLE
591 , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
592 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
593 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
594 , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
595 , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
596 , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
597 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
598 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
599 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
600 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
601 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
602 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
603 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
604 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
605 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
606 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
607 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
608 , p8_a27 in out nocopy JTF_NUMBER_TABLE
609 , p8_a28 in out nocopy JTF_NUMBER_TABLE
610 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_100
611 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
612 , p8_a31 in out nocopy JTF_NUMBER_TABLE
613 , p9_a0 in out nocopy JTF_NUMBER_TABLE
614 , p9_a1 in out nocopy JTF_NUMBER_TABLE
615 , p9_a2 in out nocopy JTF_NUMBER_TABLE
616 , p9_a3 in out nocopy JTF_NUMBER_TABLE
617 , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
618 , p9_a5 in out nocopy JTF_NUMBER_TABLE
619 , p9_a6 in out nocopy JTF_NUMBER_TABLE
620 , p9_a7 in out nocopy JTF_DATE_TABLE
621 , p9_a8 in out nocopy JTF_DATE_TABLE
622 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
623 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
624 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
625 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
626 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
627 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
628 , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
629 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
630 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
631 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
632 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
633 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
634 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
635 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
636 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
637 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
638 , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
639 , p9_a26 in out nocopy JTF_NUMBER_TABLE
640 , p9_a27 in out nocopy JTF_NUMBER_TABLE
641 , p10_a0 in out nocopy JTF_NUMBER_TABLE
642 , p10_a1 in out nocopy JTF_NUMBER_TABLE
643 , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
644 , p10_a3 in out nocopy JTF_NUMBER_TABLE
645 , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_300
646 , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
647 , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
648 , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
649 , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
650 , p10_a9 in out nocopy JTF_DATE_TABLE
651 , p10_a10 in out nocopy JTF_DATE_TABLE
652 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
653 , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
654 , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
655 , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
656 , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
657 , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
658 , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
659 , p10_a18 in out nocopy JTF_VARCHAR2_TABLE_200
660 , p10_a19 in out nocopy JTF_VARCHAR2_TABLE_200
661 , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_200
662 , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
663 , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
664 , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
665 , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
666 , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
667 , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
668 , p10_a27 in out nocopy JTF_VARCHAR2_TABLE_200
669 , p10_a28 in out nocopy JTF_NUMBER_TABLE
670 , p10_a29 in out nocopy JTF_NUMBER_TABLE
671 , p11_a0 out nocopy JTF_NUMBER_TABLE
672 , p11_a1 out nocopy JTF_NUMBER_TABLE
673 , p11_a2 out nocopy JTF_NUMBER_TABLE
674 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
675 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
676 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
677 , x_return_status out nocopy VARCHAR2
678 , x_msg_count out nocopy NUMBER
679 , x_msg_data out nocopy VARCHAR2
680 )
681
682 as
683 ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
684 ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
685 ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
686 ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
687 ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
688 ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
689 ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
690 ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
691 ddindx binary_integer; indx binary_integer;
692 begin
693
694 -- copy data to the local IN or IN-OUT args, if any
695
696
697
698
699 ddpx_mass_edit_rec.entry_id := rosetta_g_miss_num_map(p4_a0);
700 ddpx_mass_edit_rec.name := p4_a1;
701 ddpx_mass_edit_rec.txn_line_id := rosetta_g_miss_num_map(p4_a2);
702 ddpx_mass_edit_rec.txn_line_detail_id := rosetta_g_miss_num_map(p4_a3);
703 ddpx_mass_edit_rec.status_code := p4_a4;
704 ddpx_mass_edit_rec.batch_type := p4_a5;
705 ddpx_mass_edit_rec.description := p4_a6;
706 ddpx_mass_edit_rec.schedule_date := rosetta_g_miss_date_in_map(p4_a7);
707 ddpx_mass_edit_rec.start_date := rosetta_g_miss_date_in_map(p4_a8);
708 ddpx_mass_edit_rec.end_date := rosetta_g_miss_date_in_map(p4_a9);
709 ddpx_mass_edit_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
710 ddpx_mass_edit_rec.system_cascade := p4_a11;
711
712 ddpx_txn_line_rec.transaction_line_id := rosetta_g_miss_num_map(p5_a0);
713 ddpx_txn_line_rec.source_transaction_type_id := rosetta_g_miss_num_map(p5_a1);
714 ddpx_txn_line_rec.source_transaction_id := rosetta_g_miss_num_map(p5_a2);
715 ddpx_txn_line_rec.source_txn_header_id := rosetta_g_miss_num_map(p5_a3);
716 ddpx_txn_line_rec.source_transaction_table := p5_a4;
717 ddpx_txn_line_rec.config_session_hdr_id := rosetta_g_miss_num_map(p5_a5);
718 ddpx_txn_line_rec.config_session_rev_num := rosetta_g_miss_num_map(p5_a6);
719 ddpx_txn_line_rec.config_session_item_id := rosetta_g_miss_num_map(p5_a7);
720 ddpx_txn_line_rec.config_valid_status := p5_a8;
721 ddpx_txn_line_rec.source_transaction_status := p5_a9;
722 ddpx_txn_line_rec.api_caller_identity := p5_a10;
723 ddpx_txn_line_rec.inv_material_txn_flag := p5_a11;
724 ddpx_txn_line_rec.error_code := p5_a12;
725 ddpx_txn_line_rec.error_explanation := p5_a13;
726 ddpx_txn_line_rec.processing_status := p5_a14;
727 ddpx_txn_line_rec.context := p5_a15;
728 ddpx_txn_line_rec.attribute1 := p5_a16;
729 ddpx_txn_line_rec.attribute2 := p5_a17;
730 ddpx_txn_line_rec.attribute3 := p5_a18;
731 ddpx_txn_line_rec.attribute4 := p5_a19;
732 ddpx_txn_line_rec.attribute5 := p5_a20;
733 ddpx_txn_line_rec.attribute6 := p5_a21;
734 ddpx_txn_line_rec.attribute7 := p5_a22;
735 ddpx_txn_line_rec.attribute8 := p5_a23;
736 ddpx_txn_line_rec.attribute9 := p5_a24;
737 ddpx_txn_line_rec.attribute10 := p5_a25;
738 ddpx_txn_line_rec.attribute11 := p5_a26;
739 ddpx_txn_line_rec.attribute12 := p5_a27;
740 ddpx_txn_line_rec.attribute13 := p5_a28;
741 ddpx_txn_line_rec.attribute14 := p5_a29;
742 ddpx_txn_line_rec.attribute15 := p5_a30;
743 ddpx_txn_line_rec.object_version_number := rosetta_g_miss_num_map(p5_a31);
744
745 csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0
746 , p6_a1
747 , p6_a2
748 , p6_a3
749 );
750
751 ddpx_txn_line_detail_rec.txn_line_detail_id := rosetta_g_miss_num_map(p7_a0);
752 ddpx_txn_line_detail_rec.transaction_line_id := rosetta_g_miss_num_map(p7_a1);
753 ddpx_txn_line_detail_rec.sub_type_id := rosetta_g_miss_num_map(p7_a2);
754 ddpx_txn_line_detail_rec.instance_exists_flag := p7_a3;
755 ddpx_txn_line_detail_rec.source_transaction_flag := p7_a4;
756 ddpx_txn_line_detail_rec.instance_id := rosetta_g_miss_num_map(p7_a5);
757 ddpx_txn_line_detail_rec.changed_instance_id := rosetta_g_miss_num_map(p7_a6);
758 ddpx_txn_line_detail_rec.csi_system_id := rosetta_g_miss_num_map(p7_a7);
759 ddpx_txn_line_detail_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a8);
760 ddpx_txn_line_detail_rec.inventory_revision := p7_a9;
761 ddpx_txn_line_detail_rec.inv_organization_id := rosetta_g_miss_num_map(p7_a10);
762 ddpx_txn_line_detail_rec.item_condition_id := rosetta_g_miss_num_map(p7_a11);
763 ddpx_txn_line_detail_rec.instance_type_code := p7_a12;
764 ddpx_txn_line_detail_rec.quantity := rosetta_g_miss_num_map(p7_a13);
765 ddpx_txn_line_detail_rec.unit_of_measure := p7_a14;
766 ddpx_txn_line_detail_rec.qty_remaining := rosetta_g_miss_num_map(p7_a15);
767 ddpx_txn_line_detail_rec.serial_number := p7_a16;
768 ddpx_txn_line_detail_rec.mfg_serial_number_flag := p7_a17;
769 ddpx_txn_line_detail_rec.lot_number := p7_a18;
770 ddpx_txn_line_detail_rec.location_type_code := p7_a19;
771 ddpx_txn_line_detail_rec.location_id := rosetta_g_miss_num_map(p7_a20);
772 ddpx_txn_line_detail_rec.installation_date := rosetta_g_miss_date_in_map(p7_a21);
773 ddpx_txn_line_detail_rec.in_service_date := rosetta_g_miss_date_in_map(p7_a22);
774 ddpx_txn_line_detail_rec.external_reference := p7_a23;
775 ddpx_txn_line_detail_rec.transaction_system_id := rosetta_g_miss_num_map(p7_a24);
776 ddpx_txn_line_detail_rec.sellable_flag := p7_a25;
777 ddpx_txn_line_detail_rec.version_label := p7_a26;
778 ddpx_txn_line_detail_rec.return_by_date := rosetta_g_miss_date_in_map(p7_a27);
779 ddpx_txn_line_detail_rec.active_start_date := rosetta_g_miss_date_in_map(p7_a28);
780 ddpx_txn_line_detail_rec.active_end_date := rosetta_g_miss_date_in_map(p7_a29);
781 ddpx_txn_line_detail_rec.preserve_detail_flag := p7_a30;
782 ddpx_txn_line_detail_rec.reference_source_id := rosetta_g_miss_num_map(p7_a31);
783 ddpx_txn_line_detail_rec.reference_source_line_id := rosetta_g_miss_num_map(p7_a32);
784 ddpx_txn_line_detail_rec.reference_source_date := rosetta_g_miss_date_in_map(p7_a33);
785 ddpx_txn_line_detail_rec.csi_transaction_id := rosetta_g_miss_num_map(p7_a34);
786 ddpx_txn_line_detail_rec.source_txn_line_detail_id := rosetta_g_miss_num_map(p7_a35);
787 ddpx_txn_line_detail_rec.inv_mtl_transaction_id := rosetta_g_miss_num_map(p7_a36);
788 ddpx_txn_line_detail_rec.processing_status := p7_a37;
789 ddpx_txn_line_detail_rec.error_code := p7_a38;
790 ddpx_txn_line_detail_rec.error_explanation := p7_a39;
791 ddpx_txn_line_detail_rec.txn_systems_index := rosetta_g_miss_num_map(p7_a40);
792 ddpx_txn_line_detail_rec.config_inst_hdr_id := rosetta_g_miss_num_map(p7_a41);
793 ddpx_txn_line_detail_rec.config_inst_rev_num := rosetta_g_miss_num_map(p7_a42);
794 ddpx_txn_line_detail_rec.config_inst_item_id := rosetta_g_miss_num_map(p7_a43);
795 ddpx_txn_line_detail_rec.config_inst_baseline_rev_num := rosetta_g_miss_num_map(p7_a44);
796 ddpx_txn_line_detail_rec.target_commitment_date := rosetta_g_miss_date_in_map(p7_a45);
797 ddpx_txn_line_detail_rec.instance_description := p7_a46;
798 ddpx_txn_line_detail_rec.api_caller_identity := p7_a47;
799 ddpx_txn_line_detail_rec.install_location_type_code := p7_a48;
800 ddpx_txn_line_detail_rec.install_location_id := rosetta_g_miss_num_map(p7_a49);
801 ddpx_txn_line_detail_rec.cascade_owner_flag := p7_a50;
802 ddpx_txn_line_detail_rec.context := p7_a51;
803 ddpx_txn_line_detail_rec.attribute1 := p7_a52;
804 ddpx_txn_line_detail_rec.attribute2 := p7_a53;
805 ddpx_txn_line_detail_rec.attribute3 := p7_a54;
806 ddpx_txn_line_detail_rec.attribute4 := p7_a55;
807 ddpx_txn_line_detail_rec.attribute5 := p7_a56;
808 ddpx_txn_line_detail_rec.attribute6 := p7_a57;
809 ddpx_txn_line_detail_rec.attribute7 := p7_a58;
810 ddpx_txn_line_detail_rec.attribute8 := p7_a59;
811 ddpx_txn_line_detail_rec.attribute9 := p7_a60;
812 ddpx_txn_line_detail_rec.attribute10 := p7_a61;
813 ddpx_txn_line_detail_rec.attribute11 := p7_a62;
814 ddpx_txn_line_detail_rec.attribute12 := p7_a63;
815 ddpx_txn_line_detail_rec.attribute13 := p7_a64;
816 ddpx_txn_line_detail_rec.attribute14 := p7_a65;
817 ddpx_txn_line_detail_rec.attribute15 := p7_a66;
818 ddpx_txn_line_detail_rec.object_version_number := rosetta_g_miss_num_map(p7_a67);
819 ddpx_txn_line_detail_rec.parent_instance_id := rosetta_g_miss_num_map(p7_a68);
820 ddpx_txn_line_detail_rec.assc_txn_line_detail_id := rosetta_g_miss_num_map(p7_a69);
821 ddpx_txn_line_detail_rec.overriding_csi_txn_id := rosetta_g_miss_num_map(p7_a70);
822 ddpx_txn_line_detail_rec.instance_status_id := rosetta_g_miss_num_map(p7_a71);
823
824 csi_t_datastructures_grp_w.rosetta_table_copy_in_p6(ddpx_txn_party_detail_tbl, p8_a0
825 , p8_a1
826 , p8_a2
827 , p8_a3
828 , p8_a4
829 , p8_a5
830 , p8_a6
831 , p8_a7
832 , p8_a8
833 , p8_a9
834 , p8_a10
835 , p8_a11
836 , p8_a12
837 , p8_a13
838 , p8_a14
839 , p8_a15
840 , p8_a16
841 , p8_a17
842 , p8_a18
843 , p8_a19
844 , p8_a20
845 , p8_a21
846 , p8_a22
847 , p8_a23
848 , p8_a24
849 , p8_a25
850 , p8_a26
851 , p8_a27
852 , p8_a28
853 , p8_a29
854 , p8_a30
855 , p8_a31
856 );
857
858 csi_t_datastructures_grp_w.rosetta_table_copy_in_p8(ddpx_txn_pty_acct_detail_tbl, p9_a0
859 , p9_a1
860 , p9_a2
861 , p9_a3
862 , p9_a4
863 , p9_a5
864 , p9_a6
865 , p9_a7
866 , p9_a8
867 , p9_a9
868 , p9_a10
869 , p9_a11
870 , p9_a12
871 , p9_a13
872 , p9_a14
873 , p9_a15
874 , p9_a16
875 , p9_a17
876 , p9_a18
877 , p9_a19
878 , p9_a20
879 , p9_a21
880 , p9_a22
881 , p9_a23
882 , p9_a24
883 , p9_a25
884 , p9_a26
885 , p9_a27
886 );
887
888 csi_t_datastructures_grp_w.rosetta_table_copy_in_p14(ddpx_txn_ext_attrib_vals_tbl, p10_a0
889 , p10_a1
890 , p10_a2
891 , p10_a3
892 , p10_a4
893 , p10_a5
894 , p10_a6
895 , p10_a7
896 , p10_a8
897 , p10_a9
898 , p10_a10
899 , p10_a11
900 , p10_a12
901 , p10_a13
902 , p10_a14
903 , p10_a15
904 , p10_a16
905 , p10_a17
906 , p10_a18
907 , p10_a19
908 , p10_a20
909 , p10_a21
910 , p10_a22
911 , p10_a23
912 , p10_a24
913 , p10_a25
914 , p10_a26
915 , p10_a27
916 , p10_a28
917 , p10_a29
918 );
919
920
921
922
923
924 -- here's the delegated call to the old PL/SQL routine
925 csi_mass_edit_pub.create_mass_edit_batch(p_api_version,
926 p_commit,
927 p_init_msg_list,
928 p_validation_level,
929 ddpx_mass_edit_rec,
930 ddpx_txn_line_rec,
931 ddpx_mass_edit_inst_tbl,
932 ddpx_txn_line_detail_rec,
933 ddpx_txn_party_detail_tbl,
934 ddpx_txn_pty_acct_detail_tbl,
935 ddpx_txn_ext_attrib_vals_tbl,
936 ddx_mass_edit_error_tbl,
937 x_return_status,
938 x_msg_count,
939 x_msg_data);
940
941 -- copy data back from the local variables to OUT or IN-OUT args, if any
942
943
944
945
946 p4_a0 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.entry_id);
947 p4_a1 := ddpx_mass_edit_rec.name;
948 p4_a2 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_id);
949 p4_a3 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_detail_id);
950 p4_a4 := ddpx_mass_edit_rec.status_code;
951 p4_a5 := ddpx_mass_edit_rec.batch_type;
952 p4_a6 := ddpx_mass_edit_rec.description;
953 p4_a7 := ddpx_mass_edit_rec.schedule_date;
954 p4_a8 := ddpx_mass_edit_rec.start_date;
955 p4_a9 := ddpx_mass_edit_rec.end_date;
956 p4_a10 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.object_version_number);
957 p4_a11 := ddpx_mass_edit_rec.system_cascade;
958
959 p5_a0 := rosetta_g_miss_num_map(ddpx_txn_line_rec.transaction_line_id);
960 p5_a1 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_transaction_type_id);
961 p5_a2 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_transaction_id);
962 p5_a3 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_txn_header_id);
963 p5_a4 := ddpx_txn_line_rec.source_transaction_table;
964 p5_a5 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_hdr_id);
965 p5_a6 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_rev_num);
966 p5_a7 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_item_id);
967 p5_a8 := ddpx_txn_line_rec.config_valid_status;
968 p5_a9 := ddpx_txn_line_rec.source_transaction_status;
969 p5_a10 := ddpx_txn_line_rec.api_caller_identity;
970 p5_a11 := ddpx_txn_line_rec.inv_material_txn_flag;
971 p5_a12 := ddpx_txn_line_rec.error_code;
972 p5_a13 := ddpx_txn_line_rec.error_explanation;
973 p5_a14 := ddpx_txn_line_rec.processing_status;
974 p5_a15 := ddpx_txn_line_rec.context;
975 p5_a16 := ddpx_txn_line_rec.attribute1;
976 p5_a17 := ddpx_txn_line_rec.attribute2;
977 p5_a18 := ddpx_txn_line_rec.attribute3;
978 p5_a19 := ddpx_txn_line_rec.attribute4;
979 p5_a20 := ddpx_txn_line_rec.attribute5;
980 p5_a21 := ddpx_txn_line_rec.attribute6;
981 p5_a22 := ddpx_txn_line_rec.attribute7;
982 p5_a23 := ddpx_txn_line_rec.attribute8;
983 p5_a24 := ddpx_txn_line_rec.attribute9;
984 p5_a25 := ddpx_txn_line_rec.attribute10;
985 p5_a26 := ddpx_txn_line_rec.attribute11;
986 p5_a27 := ddpx_txn_line_rec.attribute12;
987 p5_a28 := ddpx_txn_line_rec.attribute13;
988 p5_a29 := ddpx_txn_line_rec.attribute14;
989 p5_a30 := ddpx_txn_line_rec.attribute15;
990 p5_a31 := rosetta_g_miss_num_map(ddpx_txn_line_rec.object_version_number);
991
992 csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0
993 , p6_a1
994 , p6_a2
995 , p6_a3
996 );
997
998 p7_a0 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.txn_line_detail_id);
999 p7_a1 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.transaction_line_id);
1000 p7_a2 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.sub_type_id);
1001 p7_a3 := ddpx_txn_line_detail_rec.instance_exists_flag;
1002 p7_a4 := ddpx_txn_line_detail_rec.source_transaction_flag;
1003 p7_a5 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.instance_id);
1004 p7_a6 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.changed_instance_id);
1005 p7_a7 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.csi_system_id);
1006 p7_a8 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inventory_item_id);
1007 p7_a9 := ddpx_txn_line_detail_rec.inventory_revision;
1008 p7_a10 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inv_organization_id);
1009 p7_a11 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.item_condition_id);
1010 p7_a12 := ddpx_txn_line_detail_rec.instance_type_code;
1011 p7_a13 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.quantity);
1012 p7_a14 := ddpx_txn_line_detail_rec.unit_of_measure;
1013 p7_a15 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.qty_remaining);
1014 p7_a16 := ddpx_txn_line_detail_rec.serial_number;
1015 p7_a17 := ddpx_txn_line_detail_rec.mfg_serial_number_flag;
1016 p7_a18 := ddpx_txn_line_detail_rec.lot_number;
1017 p7_a19 := ddpx_txn_line_detail_rec.location_type_code;
1018 p7_a20 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.location_id);
1019 p7_a21 := ddpx_txn_line_detail_rec.installation_date;
1020 p7_a22 := ddpx_txn_line_detail_rec.in_service_date;
1021 p7_a23 := ddpx_txn_line_detail_rec.external_reference;
1022 p7_a24 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.transaction_system_id);
1023 p7_a25 := ddpx_txn_line_detail_rec.sellable_flag;
1024 p7_a26 := ddpx_txn_line_detail_rec.version_label;
1025 p7_a27 := ddpx_txn_line_detail_rec.return_by_date;
1026 p7_a28 := ddpx_txn_line_detail_rec.active_start_date;
1027 p7_a29 := ddpx_txn_line_detail_rec.active_end_date;
1028 p7_a30 := ddpx_txn_line_detail_rec.preserve_detail_flag;
1029 p7_a31 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.reference_source_id);
1030 p7_a32 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.reference_source_line_id);
1031 p7_a33 := ddpx_txn_line_detail_rec.reference_source_date;
1032 p7_a34 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.csi_transaction_id);
1033 p7_a35 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.source_txn_line_detail_id);
1034 p7_a36 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inv_mtl_transaction_id);
1035 p7_a37 := ddpx_txn_line_detail_rec.processing_status;
1036 p7_a38 := ddpx_txn_line_detail_rec.error_code;
1037 p7_a39 := ddpx_txn_line_detail_rec.error_explanation;
1038 p7_a40 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.txn_systems_index);
1039 p7_a41 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_hdr_id);
1040 p7_a42 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_rev_num);
1041 p7_a43 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_item_id);
1042 p7_a44 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_baseline_rev_num);
1043 p7_a45 := ddpx_txn_line_detail_rec.target_commitment_date;
1044 p7_a46 := ddpx_txn_line_detail_rec.instance_description;
1045 p7_a47 := ddpx_txn_line_detail_rec.api_caller_identity;
1046 p7_a48 := ddpx_txn_line_detail_rec.install_location_type_code;
1047 p7_a49 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.install_location_id);
1048 p7_a50 := ddpx_txn_line_detail_rec.cascade_owner_flag;
1049 p7_a51 := ddpx_txn_line_detail_rec.context;
1050 p7_a52 := ddpx_txn_line_detail_rec.attribute1;
1051 p7_a53 := ddpx_txn_line_detail_rec.attribute2;
1052 p7_a54 := ddpx_txn_line_detail_rec.attribute3;
1053 p7_a55 := ddpx_txn_line_detail_rec.attribute4;
1054 p7_a56 := ddpx_txn_line_detail_rec.attribute5;
1055 p7_a57 := ddpx_txn_line_detail_rec.attribute6;
1056 p7_a58 := ddpx_txn_line_detail_rec.attribute7;
1057 p7_a59 := ddpx_txn_line_detail_rec.attribute8;
1058 p7_a60 := ddpx_txn_line_detail_rec.attribute9;
1059 p7_a61 := ddpx_txn_line_detail_rec.attribute10;
1060 p7_a62 := ddpx_txn_line_detail_rec.attribute11;
1061 p7_a63 := ddpx_txn_line_detail_rec.attribute12;
1062 p7_a64 := ddpx_txn_line_detail_rec.attribute13;
1063 p7_a65 := ddpx_txn_line_detail_rec.attribute14;
1064 p7_a66 := ddpx_txn_line_detail_rec.attribute15;
1065 p7_a67 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.object_version_number);
1066 p7_a68 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.parent_instance_id);
1067 p7_a69 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.assc_txn_line_detail_id);
1068 p7_a70 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.overriding_csi_txn_id);
1069 p7_a71 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.instance_status_id);
1070
1071 csi_t_datastructures_grp_w.rosetta_table_copy_out_p6(ddpx_txn_party_detail_tbl, p8_a0
1072 , p8_a1
1073 , p8_a2
1074 , p8_a3
1075 , p8_a4
1076 , p8_a5
1077 , p8_a6
1078 , p8_a7
1079 , p8_a8
1080 , p8_a9
1081 , p8_a10
1082 , p8_a11
1083 , p8_a12
1084 , p8_a13
1085 , p8_a14
1086 , p8_a15
1087 , p8_a16
1088 , p8_a17
1089 , p8_a18
1090 , p8_a19
1091 , p8_a20
1092 , p8_a21
1093 , p8_a22
1094 , p8_a23
1095 , p8_a24
1096 , p8_a25
1097 , p8_a26
1098 , p8_a27
1099 , p8_a28
1100 , p8_a29
1101 , p8_a30
1102 , p8_a31
1103 );
1104
1105 csi_t_datastructures_grp_w.rosetta_table_copy_out_p8(ddpx_txn_pty_acct_detail_tbl, p9_a0
1106 , p9_a1
1107 , p9_a2
1108 , p9_a3
1109 , p9_a4
1110 , p9_a5
1111 , p9_a6
1112 , p9_a7
1113 , p9_a8
1114 , p9_a9
1115 , p9_a10
1116 , p9_a11
1117 , p9_a12
1118 , p9_a13
1119 , p9_a14
1120 , p9_a15
1121 , p9_a16
1122 , p9_a17
1123 , p9_a18
1124 , p9_a19
1125 , p9_a20
1126 , p9_a21
1127 , p9_a22
1128 , p9_a23
1129 , p9_a24
1130 , p9_a25
1131 , p9_a26
1132 , p9_a27
1133 );
1134
1135 csi_t_datastructures_grp_w.rosetta_table_copy_out_p14(ddpx_txn_ext_attrib_vals_tbl, p10_a0
1136 , p10_a1
1137 , p10_a2
1138 , p10_a3
1139 , p10_a4
1140 , p10_a5
1141 , p10_a6
1142 , p10_a7
1143 , p10_a8
1144 , p10_a9
1145 , p10_a10
1146 , p10_a11
1147 , p10_a12
1148 , p10_a13
1149 , p10_a14
1150 , p10_a15
1151 , p10_a16
1152 , p10_a17
1153 , p10_a18
1154 , p10_a19
1155 , p10_a20
1156 , p10_a21
1157 , p10_a22
1158 , p10_a23
1159 , p10_a24
1160 , p10_a25
1161 , p10_a26
1162 , p10_a27
1163 , p10_a28
1164 , p10_a29
1165 );
1166
1167 csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0
1168 , p11_a1
1169 , p11_a2
1170 , p11_a3
1171 , p11_a4
1172 , p11_a5
1173 );
1174
1175
1176
1177 end;
1178
1179 procedure update_mass_edit_batch(p_api_version NUMBER
1180 , p_commit VARCHAR2
1181 , p_init_msg_list VARCHAR2
1182 , p_validation_level NUMBER
1183 , p4_a0 in out nocopy NUMBER
1184 , p4_a1 in out nocopy VARCHAR2
1185 , p4_a2 in out nocopy NUMBER
1186 , p4_a3 in out nocopy NUMBER
1187 , p4_a4 in out nocopy VARCHAR2
1188 , p4_a5 in out nocopy VARCHAR2
1189 , p4_a6 in out nocopy VARCHAR2
1190 , p4_a7 in out nocopy DATE
1191 , p4_a8 in out nocopy DATE
1192 , p4_a9 in out nocopy DATE
1193 , p4_a10 in out nocopy NUMBER
1194 , p4_a11 in out nocopy VARCHAR2
1195 , p5_a0 in out nocopy NUMBER
1196 , p5_a1 in out nocopy NUMBER
1197 , p5_a2 in out nocopy NUMBER
1198 , p5_a3 in out nocopy NUMBER
1199 , p5_a4 in out nocopy VARCHAR2
1200 , p5_a5 in out nocopy NUMBER
1201 , p5_a6 in out nocopy NUMBER
1202 , p5_a7 in out nocopy NUMBER
1203 , p5_a8 in out nocopy VARCHAR2
1204 , p5_a9 in out nocopy VARCHAR2
1205 , p5_a10 in out nocopy VARCHAR2
1206 , p5_a11 in out nocopy VARCHAR2
1207 , p5_a12 in out nocopy VARCHAR2
1208 , p5_a13 in out nocopy VARCHAR2
1209 , p5_a14 in out nocopy VARCHAR2
1210 , p5_a15 in out nocopy VARCHAR2
1211 , p5_a16 in out nocopy VARCHAR2
1212 , p5_a17 in out nocopy VARCHAR2
1213 , p5_a18 in out nocopy VARCHAR2
1214 , p5_a19 in out nocopy VARCHAR2
1215 , p5_a20 in out nocopy VARCHAR2
1216 , p5_a21 in out nocopy VARCHAR2
1217 , p5_a22 in out nocopy VARCHAR2
1218 , p5_a23 in out nocopy VARCHAR2
1219 , p5_a24 in out nocopy VARCHAR2
1220 , p5_a25 in out nocopy VARCHAR2
1221 , p5_a26 in out nocopy VARCHAR2
1222 , p5_a27 in out nocopy VARCHAR2
1223 , p5_a28 in out nocopy VARCHAR2
1224 , p5_a29 in out nocopy VARCHAR2
1225 , p5_a30 in out nocopy VARCHAR2
1226 , p5_a31 in out nocopy NUMBER
1227 , p6_a0 in out nocopy JTF_NUMBER_TABLE
1228 , p6_a1 in out nocopy JTF_NUMBER_TABLE
1229 , p6_a2 in out nocopy JTF_DATE_TABLE
1230 , p6_a3 in out nocopy JTF_NUMBER_TABLE
1231 , p7_a0 in out nocopy NUMBER
1232 , p7_a1 in out nocopy NUMBER
1233 , p7_a2 in out nocopy NUMBER
1234 , p7_a3 in out nocopy VARCHAR2
1235 , p7_a4 in out nocopy VARCHAR2
1236 , p7_a5 in out nocopy NUMBER
1237 , p7_a6 in out nocopy NUMBER
1238 , p7_a7 in out nocopy NUMBER
1239 , p7_a8 in out nocopy NUMBER
1240 , p7_a9 in out nocopy VARCHAR2
1241 , p7_a10 in out nocopy NUMBER
1242 , p7_a11 in out nocopy NUMBER
1243 , p7_a12 in out nocopy VARCHAR2
1244 , p7_a13 in out nocopy NUMBER
1245 , p7_a14 in out nocopy VARCHAR2
1246 , p7_a15 in out nocopy NUMBER
1247 , p7_a16 in out nocopy VARCHAR2
1248 , p7_a17 in out nocopy VARCHAR2
1249 , p7_a18 in out nocopy VARCHAR2
1250 , p7_a19 in out nocopy VARCHAR2
1251 , p7_a20 in out nocopy NUMBER
1252 , p7_a21 in out nocopy DATE
1253 , p7_a22 in out nocopy DATE
1254 , p7_a23 in out nocopy VARCHAR2
1255 , p7_a24 in out nocopy NUMBER
1256 , p7_a25 in out nocopy VARCHAR2
1257 , p7_a26 in out nocopy VARCHAR2
1258 , p7_a27 in out nocopy DATE
1259 , p7_a28 in out nocopy DATE
1260 , p7_a29 in out nocopy DATE
1261 , p7_a30 in out nocopy VARCHAR2
1262 , p7_a31 in out nocopy NUMBER
1263 , p7_a32 in out nocopy NUMBER
1264 , p7_a33 in out nocopy DATE
1265 , p7_a34 in out nocopy NUMBER
1266 , p7_a35 in out nocopy NUMBER
1267 , p7_a36 in out nocopy NUMBER
1268 , p7_a37 in out nocopy VARCHAR2
1269 , p7_a38 in out nocopy VARCHAR2
1270 , p7_a39 in out nocopy VARCHAR2
1271 , p7_a40 in out nocopy NUMBER
1272 , p7_a41 in out nocopy NUMBER
1273 , p7_a42 in out nocopy NUMBER
1274 , p7_a43 in out nocopy NUMBER
1275 , p7_a44 in out nocopy NUMBER
1276 , p7_a45 in out nocopy DATE
1277 , p7_a46 in out nocopy VARCHAR2
1278 , p7_a47 in out nocopy VARCHAR2
1279 , p7_a48 in out nocopy VARCHAR2
1280 , p7_a49 in out nocopy NUMBER
1281 , p7_a50 in out nocopy VARCHAR2
1282 , p7_a51 in out nocopy VARCHAR2
1283 , p7_a52 in out nocopy VARCHAR2
1284 , p7_a53 in out nocopy VARCHAR2
1285 , p7_a54 in out nocopy VARCHAR2
1286 , p7_a55 in out nocopy VARCHAR2
1287 , p7_a56 in out nocopy VARCHAR2
1288 , p7_a57 in out nocopy VARCHAR2
1289 , p7_a58 in out nocopy VARCHAR2
1290 , p7_a59 in out nocopy VARCHAR2
1291 , p7_a60 in out nocopy VARCHAR2
1292 , p7_a61 in out nocopy VARCHAR2
1293 , p7_a62 in out nocopy VARCHAR2
1294 , p7_a63 in out nocopy VARCHAR2
1295 , p7_a64 in out nocopy VARCHAR2
1296 , p7_a65 in out nocopy VARCHAR2
1297 , p7_a66 in out nocopy VARCHAR2
1298 , p7_a67 in out nocopy NUMBER
1299 , p7_a68 in out nocopy NUMBER
1300 , p7_a69 in out nocopy NUMBER
1301 , p7_a70 in out nocopy NUMBER
1302 , p7_a71 in out nocopy NUMBER
1303 , p8_a0 in out nocopy JTF_NUMBER_TABLE
1304 , p8_a1 in out nocopy JTF_NUMBER_TABLE
1305 , p8_a2 in out nocopy JTF_NUMBER_TABLE
1306 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1307 , p8_a4 in out nocopy JTF_NUMBER_TABLE
1308 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1309 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1310 , p8_a7 in out nocopy JTF_NUMBER_TABLE
1311 , p8_a8 in out nocopy JTF_DATE_TABLE
1312 , p8_a9 in out nocopy JTF_DATE_TABLE
1313 , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1314 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1315 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
1316 , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
1317 , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1318 , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
1319 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
1320 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1321 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1322 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1323 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1324 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1325 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1326 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
1327 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
1328 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
1329 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
1330 , p8_a27 in out nocopy JTF_NUMBER_TABLE
1331 , p8_a28 in out nocopy JTF_NUMBER_TABLE
1332 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1333 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1334 , p8_a31 in out nocopy JTF_NUMBER_TABLE
1335 , p9_a0 in out nocopy JTF_NUMBER_TABLE
1336 , p9_a1 in out nocopy JTF_NUMBER_TABLE
1337 , p9_a2 in out nocopy JTF_NUMBER_TABLE
1338 , p9_a3 in out nocopy JTF_NUMBER_TABLE
1339 , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1340 , p9_a5 in out nocopy JTF_NUMBER_TABLE
1341 , p9_a6 in out nocopy JTF_NUMBER_TABLE
1342 , p9_a7 in out nocopy JTF_DATE_TABLE
1343 , p9_a8 in out nocopy JTF_DATE_TABLE
1344 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1345 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1346 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
1347 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
1348 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
1349 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1350 , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
1351 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
1352 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1353 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1354 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1355 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1356 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1357 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1358 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
1359 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
1360 , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
1361 , p9_a26 in out nocopy JTF_NUMBER_TABLE
1362 , p9_a27 in out nocopy JTF_NUMBER_TABLE
1363 , p10_a0 in out nocopy JTF_NUMBER_TABLE
1364 , p10_a1 in out nocopy JTF_NUMBER_TABLE
1365 , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1366 , p10_a3 in out nocopy JTF_NUMBER_TABLE
1367 , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1368 , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1369 , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1370 , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1371 , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1372 , p10_a9 in out nocopy JTF_DATE_TABLE
1373 , p10_a10 in out nocopy JTF_DATE_TABLE
1374 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1375 , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1376 , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
1377 , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1378 , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
1379 , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
1380 , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1381 , p10_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1382 , p10_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1383 , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1384 , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1385 , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1386 , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
1387 , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
1388 , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
1389 , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
1390 , p10_a27 in out nocopy JTF_VARCHAR2_TABLE_200
1391 , p10_a28 in out nocopy JTF_NUMBER_TABLE
1392 , p10_a29 in out nocopy JTF_NUMBER_TABLE
1393 , p11_a0 out nocopy JTF_NUMBER_TABLE
1394 , p11_a1 out nocopy JTF_NUMBER_TABLE
1395 , p11_a2 out nocopy JTF_NUMBER_TABLE
1396 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1397 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
1398 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
1399 , x_return_status out nocopy VARCHAR2
1400 , x_msg_count out nocopy NUMBER
1401 , x_msg_data out nocopy VARCHAR2
1402 )
1403
1404 as
1405 ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1406 ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1407 ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
1408 ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
1409 ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1410 ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1411 ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1412 ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
1413 ddindx binary_integer; indx binary_integer;
1414 begin
1415
1416 -- copy data to the local IN or IN-OUT args, if any
1417
1418
1419
1420
1421 ddpx_mass_edit_rec.entry_id := rosetta_g_miss_num_map(p4_a0);
1422 ddpx_mass_edit_rec.name := p4_a1;
1423 ddpx_mass_edit_rec.txn_line_id := rosetta_g_miss_num_map(p4_a2);
1424 ddpx_mass_edit_rec.txn_line_detail_id := rosetta_g_miss_num_map(p4_a3);
1425 ddpx_mass_edit_rec.status_code := p4_a4;
1426 ddpx_mass_edit_rec.batch_type := p4_a5;
1427 ddpx_mass_edit_rec.description := p4_a6;
1428 ddpx_mass_edit_rec.schedule_date := rosetta_g_miss_date_in_map(p4_a7);
1429 ddpx_mass_edit_rec.start_date := rosetta_g_miss_date_in_map(p4_a8);
1430 ddpx_mass_edit_rec.end_date := rosetta_g_miss_date_in_map(p4_a9);
1431 ddpx_mass_edit_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
1432 ddpx_mass_edit_rec.system_cascade := p4_a11;
1433
1434 ddpx_txn_line_rec.transaction_line_id := rosetta_g_miss_num_map(p5_a0);
1435 ddpx_txn_line_rec.source_transaction_type_id := rosetta_g_miss_num_map(p5_a1);
1436 ddpx_txn_line_rec.source_transaction_id := rosetta_g_miss_num_map(p5_a2);
1437 ddpx_txn_line_rec.source_txn_header_id := rosetta_g_miss_num_map(p5_a3);
1438 ddpx_txn_line_rec.source_transaction_table := p5_a4;
1439 ddpx_txn_line_rec.config_session_hdr_id := rosetta_g_miss_num_map(p5_a5);
1440 ddpx_txn_line_rec.config_session_rev_num := rosetta_g_miss_num_map(p5_a6);
1441 ddpx_txn_line_rec.config_session_item_id := rosetta_g_miss_num_map(p5_a7);
1442 ddpx_txn_line_rec.config_valid_status := p5_a8;
1443 ddpx_txn_line_rec.source_transaction_status := p5_a9;
1444 ddpx_txn_line_rec.api_caller_identity := p5_a10;
1445 ddpx_txn_line_rec.inv_material_txn_flag := p5_a11;
1446 ddpx_txn_line_rec.error_code := p5_a12;
1447 ddpx_txn_line_rec.error_explanation := p5_a13;
1448 ddpx_txn_line_rec.processing_status := p5_a14;
1449 ddpx_txn_line_rec.context := p5_a15;
1450 ddpx_txn_line_rec.attribute1 := p5_a16;
1451 ddpx_txn_line_rec.attribute2 := p5_a17;
1452 ddpx_txn_line_rec.attribute3 := p5_a18;
1453 ddpx_txn_line_rec.attribute4 := p5_a19;
1454 ddpx_txn_line_rec.attribute5 := p5_a20;
1455 ddpx_txn_line_rec.attribute6 := p5_a21;
1456 ddpx_txn_line_rec.attribute7 := p5_a22;
1457 ddpx_txn_line_rec.attribute8 := p5_a23;
1458 ddpx_txn_line_rec.attribute9 := p5_a24;
1459 ddpx_txn_line_rec.attribute10 := p5_a25;
1460 ddpx_txn_line_rec.attribute11 := p5_a26;
1461 ddpx_txn_line_rec.attribute12 := p5_a27;
1462 ddpx_txn_line_rec.attribute13 := p5_a28;
1463 ddpx_txn_line_rec.attribute14 := p5_a29;
1464 ddpx_txn_line_rec.attribute15 := p5_a30;
1465 ddpx_txn_line_rec.object_version_number := rosetta_g_miss_num_map(p5_a31);
1466
1467 csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0
1468 , p6_a1
1469 , p6_a2
1470 , p6_a3
1471 );
1472
1473 ddpx_txn_line_detail_rec.txn_line_detail_id := rosetta_g_miss_num_map(p7_a0);
1474 ddpx_txn_line_detail_rec.transaction_line_id := rosetta_g_miss_num_map(p7_a1);
1475 ddpx_txn_line_detail_rec.sub_type_id := rosetta_g_miss_num_map(p7_a2);
1476 ddpx_txn_line_detail_rec.instance_exists_flag := p7_a3;
1477 ddpx_txn_line_detail_rec.source_transaction_flag := p7_a4;
1478 ddpx_txn_line_detail_rec.instance_id := rosetta_g_miss_num_map(p7_a5);
1479 ddpx_txn_line_detail_rec.changed_instance_id := rosetta_g_miss_num_map(p7_a6);
1480 ddpx_txn_line_detail_rec.csi_system_id := rosetta_g_miss_num_map(p7_a7);
1481 ddpx_txn_line_detail_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a8);
1482 ddpx_txn_line_detail_rec.inventory_revision := p7_a9;
1483 ddpx_txn_line_detail_rec.inv_organization_id := rosetta_g_miss_num_map(p7_a10);
1484 ddpx_txn_line_detail_rec.item_condition_id := rosetta_g_miss_num_map(p7_a11);
1485 ddpx_txn_line_detail_rec.instance_type_code := p7_a12;
1486 ddpx_txn_line_detail_rec.quantity := rosetta_g_miss_num_map(p7_a13);
1487 ddpx_txn_line_detail_rec.unit_of_measure := p7_a14;
1488 ddpx_txn_line_detail_rec.qty_remaining := rosetta_g_miss_num_map(p7_a15);
1489 ddpx_txn_line_detail_rec.serial_number := p7_a16;
1490 ddpx_txn_line_detail_rec.mfg_serial_number_flag := p7_a17;
1491 ddpx_txn_line_detail_rec.lot_number := p7_a18;
1492 ddpx_txn_line_detail_rec.location_type_code := p7_a19;
1493 ddpx_txn_line_detail_rec.location_id := rosetta_g_miss_num_map(p7_a20);
1494 ddpx_txn_line_detail_rec.installation_date := rosetta_g_miss_date_in_map(p7_a21);
1495 ddpx_txn_line_detail_rec.in_service_date := rosetta_g_miss_date_in_map(p7_a22);
1496 ddpx_txn_line_detail_rec.external_reference := p7_a23;
1497 ddpx_txn_line_detail_rec.transaction_system_id := rosetta_g_miss_num_map(p7_a24);
1498 ddpx_txn_line_detail_rec.sellable_flag := p7_a25;
1499 ddpx_txn_line_detail_rec.version_label := p7_a26;
1500 ddpx_txn_line_detail_rec.return_by_date := rosetta_g_miss_date_in_map(p7_a27);
1501 ddpx_txn_line_detail_rec.active_start_date := rosetta_g_miss_date_in_map(p7_a28);
1502 ddpx_txn_line_detail_rec.active_end_date := rosetta_g_miss_date_in_map(p7_a29);
1503 ddpx_txn_line_detail_rec.preserve_detail_flag := p7_a30;
1504 ddpx_txn_line_detail_rec.reference_source_id := rosetta_g_miss_num_map(p7_a31);
1505 ddpx_txn_line_detail_rec.reference_source_line_id := rosetta_g_miss_num_map(p7_a32);
1506 ddpx_txn_line_detail_rec.reference_source_date := rosetta_g_miss_date_in_map(p7_a33);
1507 ddpx_txn_line_detail_rec.csi_transaction_id := rosetta_g_miss_num_map(p7_a34);
1508 ddpx_txn_line_detail_rec.source_txn_line_detail_id := rosetta_g_miss_num_map(p7_a35);
1509 ddpx_txn_line_detail_rec.inv_mtl_transaction_id := rosetta_g_miss_num_map(p7_a36);
1510 ddpx_txn_line_detail_rec.processing_status := p7_a37;
1511 ddpx_txn_line_detail_rec.error_code := p7_a38;
1512 ddpx_txn_line_detail_rec.error_explanation := p7_a39;
1513 ddpx_txn_line_detail_rec.txn_systems_index := rosetta_g_miss_num_map(p7_a40);
1514 ddpx_txn_line_detail_rec.config_inst_hdr_id := rosetta_g_miss_num_map(p7_a41);
1515 ddpx_txn_line_detail_rec.config_inst_rev_num := rosetta_g_miss_num_map(p7_a42);
1516 ddpx_txn_line_detail_rec.config_inst_item_id := rosetta_g_miss_num_map(p7_a43);
1517 ddpx_txn_line_detail_rec.config_inst_baseline_rev_num := rosetta_g_miss_num_map(p7_a44);
1518 ddpx_txn_line_detail_rec.target_commitment_date := rosetta_g_miss_date_in_map(p7_a45);
1519 ddpx_txn_line_detail_rec.instance_description := p7_a46;
1520 ddpx_txn_line_detail_rec.api_caller_identity := p7_a47;
1521 ddpx_txn_line_detail_rec.install_location_type_code := p7_a48;
1522 ddpx_txn_line_detail_rec.install_location_id := rosetta_g_miss_num_map(p7_a49);
1523 ddpx_txn_line_detail_rec.cascade_owner_flag := p7_a50;
1524 ddpx_txn_line_detail_rec.context := p7_a51;
1525 ddpx_txn_line_detail_rec.attribute1 := p7_a52;
1526 ddpx_txn_line_detail_rec.attribute2 := p7_a53;
1527 ddpx_txn_line_detail_rec.attribute3 := p7_a54;
1528 ddpx_txn_line_detail_rec.attribute4 := p7_a55;
1529 ddpx_txn_line_detail_rec.attribute5 := p7_a56;
1530 ddpx_txn_line_detail_rec.attribute6 := p7_a57;
1531 ddpx_txn_line_detail_rec.attribute7 := p7_a58;
1532 ddpx_txn_line_detail_rec.attribute8 := p7_a59;
1533 ddpx_txn_line_detail_rec.attribute9 := p7_a60;
1534 ddpx_txn_line_detail_rec.attribute10 := p7_a61;
1535 ddpx_txn_line_detail_rec.attribute11 := p7_a62;
1536 ddpx_txn_line_detail_rec.attribute12 := p7_a63;
1537 ddpx_txn_line_detail_rec.attribute13 := p7_a64;
1538 ddpx_txn_line_detail_rec.attribute14 := p7_a65;
1539 ddpx_txn_line_detail_rec.attribute15 := p7_a66;
1540 ddpx_txn_line_detail_rec.object_version_number := rosetta_g_miss_num_map(p7_a67);
1541 ddpx_txn_line_detail_rec.parent_instance_id := rosetta_g_miss_num_map(p7_a68);
1542 ddpx_txn_line_detail_rec.assc_txn_line_detail_id := rosetta_g_miss_num_map(p7_a69);
1543 ddpx_txn_line_detail_rec.overriding_csi_txn_id := rosetta_g_miss_num_map(p7_a70);
1544 ddpx_txn_line_detail_rec.instance_status_id := rosetta_g_miss_num_map(p7_a71);
1545
1546 csi_t_datastructures_grp_w.rosetta_table_copy_in_p6(ddpx_txn_party_detail_tbl, p8_a0
1547 , p8_a1
1548 , p8_a2
1549 , p8_a3
1550 , p8_a4
1551 , p8_a5
1552 , p8_a6
1553 , p8_a7
1554 , p8_a8
1555 , p8_a9
1556 , p8_a10
1557 , p8_a11
1558 , p8_a12
1559 , p8_a13
1560 , p8_a14
1561 , p8_a15
1562 , p8_a16
1563 , p8_a17
1564 , p8_a18
1565 , p8_a19
1566 , p8_a20
1567 , p8_a21
1568 , p8_a22
1569 , p8_a23
1570 , p8_a24
1571 , p8_a25
1572 , p8_a26
1573 , p8_a27
1574 , p8_a28
1575 , p8_a29
1576 , p8_a30
1577 , p8_a31
1578 );
1579
1580 csi_t_datastructures_grp_w.rosetta_table_copy_in_p8(ddpx_txn_pty_acct_detail_tbl, p9_a0
1581 , p9_a1
1582 , p9_a2
1583 , p9_a3
1584 , p9_a4
1585 , p9_a5
1586 , p9_a6
1587 , p9_a7
1588 , p9_a8
1589 , p9_a9
1590 , p9_a10
1591 , p9_a11
1592 , p9_a12
1593 , p9_a13
1594 , p9_a14
1595 , p9_a15
1596 , p9_a16
1597 , p9_a17
1598 , p9_a18
1599 , p9_a19
1600 , p9_a20
1601 , p9_a21
1602 , p9_a22
1603 , p9_a23
1604 , p9_a24
1605 , p9_a25
1606 , p9_a26
1607 , p9_a27
1608 );
1609
1610 csi_t_datastructures_grp_w.rosetta_table_copy_in_p14(ddpx_txn_ext_attrib_vals_tbl, p10_a0
1611 , p10_a1
1612 , p10_a2
1613 , p10_a3
1614 , p10_a4
1615 , p10_a5
1616 , p10_a6
1617 , p10_a7
1618 , p10_a8
1619 , p10_a9
1620 , p10_a10
1621 , p10_a11
1622 , p10_a12
1623 , p10_a13
1624 , p10_a14
1625 , p10_a15
1626 , p10_a16
1627 , p10_a17
1628 , p10_a18
1629 , p10_a19
1630 , p10_a20
1631 , p10_a21
1632 , p10_a22
1633 , p10_a23
1634 , p10_a24
1635 , p10_a25
1636 , p10_a26
1637 , p10_a27
1638 , p10_a28
1639 , p10_a29
1640 );
1641
1642
1643
1644
1645
1646 -- here's the delegated call to the old PL/SQL routine
1647 csi_mass_edit_pub.update_mass_edit_batch(p_api_version,
1648 p_commit,
1649 p_init_msg_list,
1650 p_validation_level,
1651 ddpx_mass_edit_rec,
1652 ddpx_txn_line_rec,
1653 ddpx_mass_edit_inst_tbl,
1654 ddpx_txn_line_detail_rec,
1655 ddpx_txn_party_detail_tbl,
1656 ddpx_txn_pty_acct_detail_tbl,
1657 ddpx_txn_ext_attrib_vals_tbl,
1658 ddx_mass_edit_error_tbl,
1659 x_return_status,
1660 x_msg_count,
1661 x_msg_data);
1662
1663 -- copy data back from the local variables to OUT or IN-OUT args, if any
1664
1665
1666
1667
1668 p4_a0 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.entry_id);
1669 p4_a1 := ddpx_mass_edit_rec.name;
1670 p4_a2 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_id);
1671 p4_a3 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_detail_id);
1672 p4_a4 := ddpx_mass_edit_rec.status_code;
1673 p4_a5 := ddpx_mass_edit_rec.batch_type;
1674 p4_a6 := ddpx_mass_edit_rec.description;
1675 p4_a7 := ddpx_mass_edit_rec.schedule_date;
1676 p4_a8 := ddpx_mass_edit_rec.start_date;
1677 p4_a9 := ddpx_mass_edit_rec.end_date;
1678 p4_a10 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.object_version_number);
1679 p4_a11 := ddpx_mass_edit_rec.system_cascade;
1680
1681 p5_a0 := rosetta_g_miss_num_map(ddpx_txn_line_rec.transaction_line_id);
1682 p5_a1 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_transaction_type_id);
1683 p5_a2 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_transaction_id);
1684 p5_a3 := rosetta_g_miss_num_map(ddpx_txn_line_rec.source_txn_header_id);
1685 p5_a4 := ddpx_txn_line_rec.source_transaction_table;
1686 p5_a5 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_hdr_id);
1687 p5_a6 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_rev_num);
1688 p5_a7 := rosetta_g_miss_num_map(ddpx_txn_line_rec.config_session_item_id);
1689 p5_a8 := ddpx_txn_line_rec.config_valid_status;
1690 p5_a9 := ddpx_txn_line_rec.source_transaction_status;
1691 p5_a10 := ddpx_txn_line_rec.api_caller_identity;
1692 p5_a11 := ddpx_txn_line_rec.inv_material_txn_flag;
1693 p5_a12 := ddpx_txn_line_rec.error_code;
1694 p5_a13 := ddpx_txn_line_rec.error_explanation;
1695 p5_a14 := ddpx_txn_line_rec.processing_status;
1696 p5_a15 := ddpx_txn_line_rec.context;
1697 p5_a16 := ddpx_txn_line_rec.attribute1;
1698 p5_a17 := ddpx_txn_line_rec.attribute2;
1699 p5_a18 := ddpx_txn_line_rec.attribute3;
1700 p5_a19 := ddpx_txn_line_rec.attribute4;
1701 p5_a20 := ddpx_txn_line_rec.attribute5;
1702 p5_a21 := ddpx_txn_line_rec.attribute6;
1703 p5_a22 := ddpx_txn_line_rec.attribute7;
1704 p5_a23 := ddpx_txn_line_rec.attribute8;
1705 p5_a24 := ddpx_txn_line_rec.attribute9;
1706 p5_a25 := ddpx_txn_line_rec.attribute10;
1707 p5_a26 := ddpx_txn_line_rec.attribute11;
1708 p5_a27 := ddpx_txn_line_rec.attribute12;
1709 p5_a28 := ddpx_txn_line_rec.attribute13;
1710 p5_a29 := ddpx_txn_line_rec.attribute14;
1711 p5_a30 := ddpx_txn_line_rec.attribute15;
1712 p5_a31 := rosetta_g_miss_num_map(ddpx_txn_line_rec.object_version_number);
1713
1714 csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0
1715 , p6_a1
1716 , p6_a2
1717 , p6_a3
1718 );
1719
1720 p7_a0 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.txn_line_detail_id);
1721 p7_a1 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.transaction_line_id);
1722 p7_a2 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.sub_type_id);
1723 p7_a3 := ddpx_txn_line_detail_rec.instance_exists_flag;
1724 p7_a4 := ddpx_txn_line_detail_rec.source_transaction_flag;
1725 p7_a5 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.instance_id);
1726 p7_a6 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.changed_instance_id);
1727 p7_a7 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.csi_system_id);
1728 p7_a8 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inventory_item_id);
1729 p7_a9 := ddpx_txn_line_detail_rec.inventory_revision;
1730 p7_a10 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inv_organization_id);
1731 p7_a11 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.item_condition_id);
1732 p7_a12 := ddpx_txn_line_detail_rec.instance_type_code;
1733 p7_a13 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.quantity);
1734 p7_a14 := ddpx_txn_line_detail_rec.unit_of_measure;
1735 p7_a15 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.qty_remaining);
1736 p7_a16 := ddpx_txn_line_detail_rec.serial_number;
1737 p7_a17 := ddpx_txn_line_detail_rec.mfg_serial_number_flag;
1738 p7_a18 := ddpx_txn_line_detail_rec.lot_number;
1739 p7_a19 := ddpx_txn_line_detail_rec.location_type_code;
1740 p7_a20 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.location_id);
1741 p7_a21 := ddpx_txn_line_detail_rec.installation_date;
1742 p7_a22 := ddpx_txn_line_detail_rec.in_service_date;
1743 p7_a23 := ddpx_txn_line_detail_rec.external_reference;
1744 p7_a24 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.transaction_system_id);
1745 p7_a25 := ddpx_txn_line_detail_rec.sellable_flag;
1746 p7_a26 := ddpx_txn_line_detail_rec.version_label;
1747 p7_a27 := ddpx_txn_line_detail_rec.return_by_date;
1748 p7_a28 := ddpx_txn_line_detail_rec.active_start_date;
1749 p7_a29 := ddpx_txn_line_detail_rec.active_end_date;
1750 p7_a30 := ddpx_txn_line_detail_rec.preserve_detail_flag;
1751 p7_a31 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.reference_source_id);
1752 p7_a32 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.reference_source_line_id);
1753 p7_a33 := ddpx_txn_line_detail_rec.reference_source_date;
1754 p7_a34 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.csi_transaction_id);
1755 p7_a35 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.source_txn_line_detail_id);
1756 p7_a36 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.inv_mtl_transaction_id);
1757 p7_a37 := ddpx_txn_line_detail_rec.processing_status;
1758 p7_a38 := ddpx_txn_line_detail_rec.error_code;
1759 p7_a39 := ddpx_txn_line_detail_rec.error_explanation;
1760 p7_a40 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.txn_systems_index);
1761 p7_a41 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_hdr_id);
1762 p7_a42 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_rev_num);
1763 p7_a43 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_item_id);
1764 p7_a44 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.config_inst_baseline_rev_num);
1765 p7_a45 := ddpx_txn_line_detail_rec.target_commitment_date;
1766 p7_a46 := ddpx_txn_line_detail_rec.instance_description;
1767 p7_a47 := ddpx_txn_line_detail_rec.api_caller_identity;
1768 p7_a48 := ddpx_txn_line_detail_rec.install_location_type_code;
1769 p7_a49 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.install_location_id);
1770 p7_a50 := ddpx_txn_line_detail_rec.cascade_owner_flag;
1771 p7_a51 := ddpx_txn_line_detail_rec.context;
1772 p7_a52 := ddpx_txn_line_detail_rec.attribute1;
1773 p7_a53 := ddpx_txn_line_detail_rec.attribute2;
1774 p7_a54 := ddpx_txn_line_detail_rec.attribute3;
1775 p7_a55 := ddpx_txn_line_detail_rec.attribute4;
1776 p7_a56 := ddpx_txn_line_detail_rec.attribute5;
1777 p7_a57 := ddpx_txn_line_detail_rec.attribute6;
1778 p7_a58 := ddpx_txn_line_detail_rec.attribute7;
1779 p7_a59 := ddpx_txn_line_detail_rec.attribute8;
1780 p7_a60 := ddpx_txn_line_detail_rec.attribute9;
1781 p7_a61 := ddpx_txn_line_detail_rec.attribute10;
1782 p7_a62 := ddpx_txn_line_detail_rec.attribute11;
1783 p7_a63 := ddpx_txn_line_detail_rec.attribute12;
1784 p7_a64 := ddpx_txn_line_detail_rec.attribute13;
1785 p7_a65 := ddpx_txn_line_detail_rec.attribute14;
1786 p7_a66 := ddpx_txn_line_detail_rec.attribute15;
1787 p7_a67 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.object_version_number);
1788 p7_a68 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.parent_instance_id);
1789 p7_a69 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.assc_txn_line_detail_id);
1790 p7_a70 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.overriding_csi_txn_id);
1791 p7_a71 := rosetta_g_miss_num_map(ddpx_txn_line_detail_rec.instance_status_id);
1792
1793 csi_t_datastructures_grp_w.rosetta_table_copy_out_p6(ddpx_txn_party_detail_tbl, p8_a0
1794 , p8_a1
1795 , p8_a2
1796 , p8_a3
1797 , p8_a4
1798 , p8_a5
1799 , p8_a6
1800 , p8_a7
1801 , p8_a8
1802 , p8_a9
1803 , p8_a10
1804 , p8_a11
1805 , p8_a12
1806 , p8_a13
1807 , p8_a14
1808 , p8_a15
1809 , p8_a16
1810 , p8_a17
1811 , p8_a18
1812 , p8_a19
1813 , p8_a20
1814 , p8_a21
1815 , p8_a22
1816 , p8_a23
1817 , p8_a24
1818 , p8_a25
1819 , p8_a26
1820 , p8_a27
1821 , p8_a28
1822 , p8_a29
1823 , p8_a30
1824 , p8_a31
1825 );
1826
1827 csi_t_datastructures_grp_w.rosetta_table_copy_out_p8(ddpx_txn_pty_acct_detail_tbl, p9_a0
1828 , p9_a1
1829 , p9_a2
1830 , p9_a3
1831 , p9_a4
1832 , p9_a5
1833 , p9_a6
1834 , p9_a7
1835 , p9_a8
1836 , p9_a9
1837 , p9_a10
1838 , p9_a11
1839 , p9_a12
1840 , p9_a13
1841 , p9_a14
1842 , p9_a15
1843 , p9_a16
1844 , p9_a17
1845 , p9_a18
1846 , p9_a19
1847 , p9_a20
1848 , p9_a21
1849 , p9_a22
1850 , p9_a23
1851 , p9_a24
1852 , p9_a25
1853 , p9_a26
1854 , p9_a27
1855 );
1856
1857 csi_t_datastructures_grp_w.rosetta_table_copy_out_p14(ddpx_txn_ext_attrib_vals_tbl, p10_a0
1858 , p10_a1
1859 , p10_a2
1860 , p10_a3
1861 , p10_a4
1862 , p10_a5
1863 , p10_a6
1864 , p10_a7
1865 , p10_a8
1866 , p10_a9
1867 , p10_a10
1868 , p10_a11
1869 , p10_a12
1870 , p10_a13
1871 , p10_a14
1872 , p10_a15
1873 , p10_a16
1874 , p10_a17
1875 , p10_a18
1876 , p10_a19
1877 , p10_a20
1878 , p10_a21
1879 , p10_a22
1880 , p10_a23
1881 , p10_a24
1882 , p10_a25
1883 , p10_a26
1884 , p10_a27
1885 , p10_a28
1886 , p10_a29
1887 );
1888
1889 csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0
1890 , p11_a1
1891 , p11_a2
1892 , p11_a3
1893 , p11_a4
1894 , p11_a5
1895 );
1896
1897
1898
1899 end;
1900
1901 procedure delete_mass_edit_batch(p_api_version NUMBER
1902 , p_commit VARCHAR2
1903 , p_init_msg_list VARCHAR2
1904 , p_validation_level NUMBER
1905 , x_return_status out nocopy VARCHAR2
1906 , x_msg_count out nocopy NUMBER
1907 , x_msg_data out nocopy VARCHAR2
1908 , p4_a0 NUMBER := 0-1962.0724
1909 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
1910 , p4_a2 NUMBER := 0-1962.0724
1911 , p4_a3 NUMBER := 0-1962.0724
1912 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
1913 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
1914 , p4_a6 VARCHAR2 := fnd_api.g_miss_char
1915 , p4_a7 DATE := fnd_api.g_miss_date
1916 , p4_a8 DATE := fnd_api.g_miss_date
1917 , p4_a9 DATE := fnd_api.g_miss_date
1918 , p4_a10 NUMBER := 0-1962.0724
1919 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
1920 )
1921
1922 as
1923 ddp_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1924 ddindx binary_integer; indx binary_integer;
1925 begin
1926
1927 -- copy data to the local IN or IN-OUT args, if any
1928
1929
1930
1931
1932 ddp_mass_edit_rec.entry_id := rosetta_g_miss_num_map(p4_a0);
1933 ddp_mass_edit_rec.name := p4_a1;
1934 ddp_mass_edit_rec.txn_line_id := rosetta_g_miss_num_map(p4_a2);
1935 ddp_mass_edit_rec.txn_line_detail_id := rosetta_g_miss_num_map(p4_a3);
1936 ddp_mass_edit_rec.status_code := p4_a4;
1937 ddp_mass_edit_rec.batch_type := p4_a5;
1938 ddp_mass_edit_rec.description := p4_a6;
1939 ddp_mass_edit_rec.schedule_date := rosetta_g_miss_date_in_map(p4_a7);
1940 ddp_mass_edit_rec.start_date := rosetta_g_miss_date_in_map(p4_a8);
1941 ddp_mass_edit_rec.end_date := rosetta_g_miss_date_in_map(p4_a9);
1942 ddp_mass_edit_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
1943 ddp_mass_edit_rec.system_cascade := p4_a11;
1944
1945
1946
1947
1948 -- here's the delegated call to the old PL/SQL routine
1949 csi_mass_edit_pub.delete_mass_edit_batch(p_api_version,
1950 p_commit,
1951 p_init_msg_list,
1952 p_validation_level,
1953 ddp_mass_edit_rec,
1954 x_return_status,
1955 x_msg_count,
1956 x_msg_data);
1957
1958 -- copy data back from the local variables to OUT or IN-OUT args, if any
1959
1960
1961
1962
1963
1964
1965
1966 end;
1967
1968 procedure delete_mass_edit_batches(p_api_version NUMBER
1969 , p_commit VARCHAR2
1970 , p_init_msg_list VARCHAR2
1971 , p_validation_level NUMBER
1972 , p4_a0 JTF_NUMBER_TABLE
1973 , p4_a1 JTF_VARCHAR2_TABLE_100
1974 , p4_a2 JTF_NUMBER_TABLE
1975 , p4_a3 JTF_NUMBER_TABLE
1976 , p4_a4 JTF_VARCHAR2_TABLE_100
1977 , p4_a5 JTF_VARCHAR2_TABLE_100
1978 , p4_a6 JTF_VARCHAR2_TABLE_2000
1979 , p4_a7 JTF_DATE_TABLE
1980 , p4_a8 JTF_DATE_TABLE
1981 , p4_a9 JTF_DATE_TABLE
1982 , p4_a10 JTF_NUMBER_TABLE
1983 , p4_a11 JTF_VARCHAR2_TABLE_100
1984 , x_return_status out nocopy VARCHAR2
1985 , x_msg_count out nocopy NUMBER
1986 , x_msg_data out nocopy VARCHAR2
1987 )
1988
1989 as
1990 ddp_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;
1991 ddindx binary_integer; indx binary_integer;
1992 begin
1993
1994 -- copy data to the local IN or IN-OUT args, if any
1995
1996
1997
1998
1999 csi_mass_edit_pub_w.rosetta_table_copy_in_p4(ddp_mass_edit_tbl, p4_a0
2000 , p4_a1
2001 , p4_a2
2002 , p4_a3
2003 , p4_a4
2004 , p4_a5
2005 , p4_a6
2006 , p4_a7
2007 , p4_a8
2008 , p4_a9
2009 , p4_a10
2010 , p4_a11
2011 );
2012
2013
2014
2015
2016 -- here's the delegated call to the old PL/SQL routine
2017 csi_mass_edit_pub.delete_mass_edit_batches(p_api_version,
2018 p_commit,
2019 p_init_msg_list,
2020 p_validation_level,
2021 ddp_mass_edit_tbl,
2022 x_return_status,
2023 x_msg_count,
2024 x_msg_data);
2025
2026 -- copy data back from the local variables to OUT or IN-OUT args, if any
2027
2028
2029
2030
2031
2032
2033
2034 end;
2035
2036 procedure get_mass_edit_details(p_api_version NUMBER
2037 , p_commit VARCHAR2
2038 , p_init_msg_list VARCHAR2
2039 , p_validation_level NUMBER
2040 , p4_a0 in out nocopy NUMBER
2041 , p4_a1 in out nocopy VARCHAR2
2042 , p4_a2 in out nocopy NUMBER
2043 , p4_a3 in out nocopy NUMBER
2044 , p4_a4 in out nocopy VARCHAR2
2045 , p4_a5 in out nocopy VARCHAR2
2046 , p4_a6 in out nocopy VARCHAR2
2047 , p4_a7 in out nocopy DATE
2048 , p4_a8 in out nocopy DATE
2049 , p4_a9 in out nocopy DATE
2050 , p4_a10 in out nocopy NUMBER
2051 , p4_a11 in out nocopy VARCHAR2
2052 , p5_a0 out nocopy JTF_NUMBER_TABLE
2053 , p5_a1 out nocopy JTF_NUMBER_TABLE
2054 , p5_a2 out nocopy JTF_NUMBER_TABLE
2055 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
2056 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2057 , p5_a5 out nocopy JTF_NUMBER_TABLE
2058 , p5_a6 out nocopy JTF_NUMBER_TABLE
2059 , p5_a7 out nocopy JTF_NUMBER_TABLE
2060 , p5_a8 out nocopy JTF_NUMBER_TABLE
2061 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
2062 , p5_a10 out nocopy JTF_NUMBER_TABLE
2063 , p5_a11 out nocopy JTF_NUMBER_TABLE
2064 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
2065 , p5_a13 out nocopy JTF_NUMBER_TABLE
2066 , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
2067 , p5_a15 out nocopy JTF_NUMBER_TABLE
2068 , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2069 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
2070 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
2071 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2072 , p5_a20 out nocopy JTF_NUMBER_TABLE
2073 , p5_a21 out nocopy JTF_DATE_TABLE
2074 , p5_a22 out nocopy JTF_DATE_TABLE
2075 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2076 , p5_a24 out nocopy JTF_NUMBER_TABLE
2077 , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
2078 , p5_a26 out nocopy JTF_VARCHAR2_TABLE_300
2079 , p5_a27 out nocopy JTF_DATE_TABLE
2080 , p5_a28 out nocopy JTF_DATE_TABLE
2081 , p5_a29 out nocopy JTF_DATE_TABLE
2082 , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
2083 , p5_a31 out nocopy JTF_NUMBER_TABLE
2084 , p5_a32 out nocopy JTF_NUMBER_TABLE
2085 , p5_a33 out nocopy JTF_DATE_TABLE
2086 , p5_a34 out nocopy JTF_NUMBER_TABLE
2087 , p5_a35 out nocopy JTF_NUMBER_TABLE
2088 , p5_a36 out nocopy JTF_NUMBER_TABLE
2089 , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
2090 , p5_a38 out nocopy JTF_VARCHAR2_TABLE_300
2091 , p5_a39 out nocopy JTF_VARCHAR2_TABLE_300
2092 , p5_a40 out nocopy JTF_NUMBER_TABLE
2093 , p5_a41 out nocopy JTF_NUMBER_TABLE
2094 , p5_a42 out nocopy JTF_NUMBER_TABLE
2095 , p5_a43 out nocopy JTF_NUMBER_TABLE
2096 , p5_a44 out nocopy JTF_NUMBER_TABLE
2097 , p5_a45 out nocopy JTF_DATE_TABLE
2098 , p5_a46 out nocopy JTF_VARCHAR2_TABLE_300
2099 , p5_a47 out nocopy JTF_VARCHAR2_TABLE_100
2100 , p5_a48 out nocopy JTF_VARCHAR2_TABLE_100
2101 , p5_a49 out nocopy JTF_NUMBER_TABLE
2102 , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
2103 , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
2104 , p5_a52 out nocopy JTF_VARCHAR2_TABLE_200
2105 , p5_a53 out nocopy JTF_VARCHAR2_TABLE_200
2106 , p5_a54 out nocopy JTF_VARCHAR2_TABLE_200
2107 , p5_a55 out nocopy JTF_VARCHAR2_TABLE_200
2108 , p5_a56 out nocopy JTF_VARCHAR2_TABLE_200
2109 , p5_a57 out nocopy JTF_VARCHAR2_TABLE_200
2110 , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
2111 , p5_a59 out nocopy JTF_VARCHAR2_TABLE_200
2112 , p5_a60 out nocopy JTF_VARCHAR2_TABLE_200
2113 , p5_a61 out nocopy JTF_VARCHAR2_TABLE_200
2114 , p5_a62 out nocopy JTF_VARCHAR2_TABLE_200
2115 , p5_a63 out nocopy JTF_VARCHAR2_TABLE_200
2116 , p5_a64 out nocopy JTF_VARCHAR2_TABLE_200
2117 , p5_a65 out nocopy JTF_VARCHAR2_TABLE_200
2118 , p5_a66 out nocopy JTF_VARCHAR2_TABLE_200
2119 , p5_a67 out nocopy JTF_NUMBER_TABLE
2120 , p5_a68 out nocopy JTF_NUMBER_TABLE
2121 , p5_a69 out nocopy JTF_NUMBER_TABLE
2122 , p5_a70 out nocopy JTF_NUMBER_TABLE
2123 , p5_a71 out nocopy JTF_NUMBER_TABLE
2124 , p6_a0 out nocopy JTF_NUMBER_TABLE
2125 , p6_a1 out nocopy JTF_NUMBER_TABLE
2126 , p6_a2 out nocopy JTF_NUMBER_TABLE
2127 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2128 , p6_a4 out nocopy JTF_NUMBER_TABLE
2129 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2130 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2131 , p6_a7 out nocopy JTF_NUMBER_TABLE
2132 , p6_a8 out nocopy JTF_DATE_TABLE
2133 , p6_a9 out nocopy JTF_DATE_TABLE
2134 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2135 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2136 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
2137 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2138 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
2139 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2140 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
2141 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
2142 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
2143 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
2144 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2145 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2146 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
2147 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_200
2148 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
2149 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_200
2150 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_200
2151 , p6_a27 out nocopy JTF_NUMBER_TABLE
2152 , p6_a28 out nocopy JTF_NUMBER_TABLE
2153 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
2154 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2155 , p6_a31 out nocopy JTF_NUMBER_TABLE
2156 , p7_a0 out nocopy JTF_NUMBER_TABLE
2157 , p7_a1 out nocopy JTF_NUMBER_TABLE
2158 , p7_a2 out nocopy JTF_NUMBER_TABLE
2159 , p7_a3 out nocopy JTF_NUMBER_TABLE
2160 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
2161 , p7_a5 out nocopy JTF_NUMBER_TABLE
2162 , p7_a6 out nocopy JTF_NUMBER_TABLE
2163 , p7_a7 out nocopy JTF_DATE_TABLE
2164 , p7_a8 out nocopy JTF_DATE_TABLE
2165 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
2166 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
2167 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_200
2168 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_200
2169 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_200
2170 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_200
2171 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_200
2172 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_200
2173 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
2174 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
2175 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
2176 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
2177 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_200
2178 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
2179 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_200
2180 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
2181 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
2182 , p7_a26 out nocopy JTF_NUMBER_TABLE
2183 , p7_a27 out nocopy JTF_NUMBER_TABLE
2184 , p8_a0 out nocopy JTF_NUMBER_TABLE
2185 , p8_a1 out nocopy JTF_NUMBER_TABLE
2186 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
2187 , p8_a3 out nocopy JTF_NUMBER_TABLE
2188 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
2189 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
2190 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
2191 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
2192 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
2193 , p8_a9 out nocopy JTF_DATE_TABLE
2194 , p8_a10 out nocopy JTF_DATE_TABLE
2195 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
2196 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
2197 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
2198 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
2199 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_200
2200 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
2201 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
2202 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
2203 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200
2204 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_200
2205 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
2206 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
2207 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
2208 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
2209 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
2210 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
2211 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
2212 , p8_a28 out nocopy JTF_NUMBER_TABLE
2213 , p8_a29 out nocopy JTF_NUMBER_TABLE
2214 , x_return_status out nocopy VARCHAR2
2215 , x_msg_count out nocopy NUMBER
2216 , x_msg_data out nocopy VARCHAR2
2217 )
2218
2219 as
2220 ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
2221 ddx_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2222 ddx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2223 ddx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2224 ddx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2225 ddindx binary_integer; indx binary_integer;
2226 begin
2227
2228 -- copy data to the local IN or IN-OUT args, if any
2229
2230
2231
2232
2233 ddpx_mass_edit_rec.entry_id := rosetta_g_miss_num_map(p4_a0);
2234 ddpx_mass_edit_rec.name := p4_a1;
2235 ddpx_mass_edit_rec.txn_line_id := rosetta_g_miss_num_map(p4_a2);
2236 ddpx_mass_edit_rec.txn_line_detail_id := rosetta_g_miss_num_map(p4_a3);
2237 ddpx_mass_edit_rec.status_code := p4_a4;
2238 ddpx_mass_edit_rec.batch_type := p4_a5;
2239 ddpx_mass_edit_rec.description := p4_a6;
2240 ddpx_mass_edit_rec.schedule_date := rosetta_g_miss_date_in_map(p4_a7);
2241 ddpx_mass_edit_rec.start_date := rosetta_g_miss_date_in_map(p4_a8);
2242 ddpx_mass_edit_rec.end_date := rosetta_g_miss_date_in_map(p4_a9);
2243 ddpx_mass_edit_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
2244 ddpx_mass_edit_rec.system_cascade := p4_a11;
2245
2246
2247
2248
2249
2250
2251
2252
2253 -- here's the delegated call to the old PL/SQL routine
2254 csi_mass_edit_pub.get_mass_edit_details(p_api_version,
2255 p_commit,
2256 p_init_msg_list,
2257 p_validation_level,
2258 ddpx_mass_edit_rec,
2259 ddx_txn_line_detail_tbl,
2260 ddx_txn_party_detail_tbl,
2261 ddx_txn_pty_acct_detail_tbl,
2262 ddx_txn_ext_attrib_vals_tbl,
2263 x_return_status,
2264 x_msg_count,
2265 x_msg_data);
2266
2267 -- copy data back from the local variables to OUT or IN-OUT args, if any
2268
2269
2270
2271
2272 p4_a0 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.entry_id);
2273 p4_a1 := ddpx_mass_edit_rec.name;
2274 p4_a2 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_id);
2275 p4_a3 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.txn_line_detail_id);
2276 p4_a4 := ddpx_mass_edit_rec.status_code;
2277 p4_a5 := ddpx_mass_edit_rec.batch_type;
2278 p4_a6 := ddpx_mass_edit_rec.description;
2279 p4_a7 := ddpx_mass_edit_rec.schedule_date;
2280 p4_a8 := ddpx_mass_edit_rec.start_date;
2281 p4_a9 := ddpx_mass_edit_rec.end_date;
2282 p4_a10 := rosetta_g_miss_num_map(ddpx_mass_edit_rec.object_version_number);
2283 p4_a11 := ddpx_mass_edit_rec.system_cascade;
2284
2285 csi_t_datastructures_grp_w.rosetta_table_copy_out_p4(ddx_txn_line_detail_tbl, p5_a0
2286 , p5_a1
2287 , p5_a2
2288 , p5_a3
2289 , p5_a4
2290 , p5_a5
2291 , p5_a6
2292 , p5_a7
2293 , p5_a8
2294 , p5_a9
2295 , p5_a10
2296 , p5_a11
2297 , p5_a12
2298 , p5_a13
2299 , p5_a14
2300 , p5_a15
2301 , p5_a16
2302 , p5_a17
2303 , p5_a18
2304 , p5_a19
2305 , p5_a20
2306 , p5_a21
2307 , p5_a22
2308 , p5_a23
2309 , p5_a24
2310 , p5_a25
2311 , p5_a26
2312 , p5_a27
2313 , p5_a28
2314 , p5_a29
2315 , p5_a30
2316 , p5_a31
2317 , p5_a32
2318 , p5_a33
2319 , p5_a34
2320 , p5_a35
2321 , p5_a36
2322 , p5_a37
2323 , p5_a38
2324 , p5_a39
2325 , p5_a40
2326 , p5_a41
2327 , p5_a42
2328 , p5_a43
2329 , p5_a44
2330 , p5_a45
2331 , p5_a46
2332 , p5_a47
2333 , p5_a48
2334 , p5_a49
2335 , p5_a50
2336 , p5_a51
2337 , p5_a52
2338 , p5_a53
2339 , p5_a54
2340 , p5_a55
2341 , p5_a56
2342 , p5_a57
2343 , p5_a58
2344 , p5_a59
2345 , p5_a60
2346 , p5_a61
2347 , p5_a62
2348 , p5_a63
2349 , p5_a64
2350 , p5_a65
2351 , p5_a66
2352 , p5_a67
2353 , p5_a68
2354 , p5_a69
2355 , p5_a70
2356 , p5_a71
2357 );
2358
2359 csi_t_datastructures_grp_w.rosetta_table_copy_out_p6(ddx_txn_party_detail_tbl, p6_a0
2360 , p6_a1
2361 , p6_a2
2362 , p6_a3
2363 , p6_a4
2364 , p6_a5
2365 , p6_a6
2366 , p6_a7
2367 , p6_a8
2368 , p6_a9
2369 , p6_a10
2370 , p6_a11
2371 , p6_a12
2372 , p6_a13
2373 , p6_a14
2374 , p6_a15
2375 , p6_a16
2376 , p6_a17
2377 , p6_a18
2378 , p6_a19
2379 , p6_a20
2380 , p6_a21
2381 , p6_a22
2382 , p6_a23
2383 , p6_a24
2384 , p6_a25
2385 , p6_a26
2386 , p6_a27
2387 , p6_a28
2388 , p6_a29
2389 , p6_a30
2390 , p6_a31
2391 );
2392
2393 csi_t_datastructures_grp_w.rosetta_table_copy_out_p8(ddx_txn_pty_acct_detail_tbl, p7_a0
2394 , p7_a1
2395 , p7_a2
2396 , p7_a3
2397 , p7_a4
2398 , p7_a5
2399 , p7_a6
2400 , p7_a7
2401 , p7_a8
2402 , p7_a9
2403 , p7_a10
2404 , p7_a11
2405 , p7_a12
2406 , p7_a13
2407 , p7_a14
2408 , p7_a15
2409 , p7_a16
2410 , p7_a17
2411 , p7_a18
2412 , p7_a19
2413 , p7_a20
2414 , p7_a21
2415 , p7_a22
2416 , p7_a23
2417 , p7_a24
2418 , p7_a25
2419 , p7_a26
2420 , p7_a27
2421 );
2422
2423 csi_t_datastructures_grp_w.rosetta_table_copy_out_p14(ddx_txn_ext_attrib_vals_tbl, p8_a0
2424 , p8_a1
2425 , p8_a2
2426 , p8_a3
2427 , p8_a4
2428 , p8_a5
2429 , p8_a6
2430 , p8_a7
2431 , p8_a8
2432 , p8_a9
2433 , p8_a10
2434 , p8_a11
2435 , p8_a12
2436 , p8_a13
2437 , p8_a14
2438 , p8_a15
2439 , p8_a16
2440 , p8_a17
2441 , p8_a18
2442 , p8_a19
2443 , p8_a20
2444 , p8_a21
2445 , p8_a22
2446 , p8_a23
2447 , p8_a24
2448 , p8_a25
2449 , p8_a26
2450 , p8_a27
2451 , p8_a28
2452 , p8_a29
2453 );
2454
2455
2456
2457 end;
2458
2459 procedure process_system_mass_update(p_api_version NUMBER
2460 , p_commit VARCHAR2
2461 , p_entry_id NUMBER
2462 , p3_a0 in out nocopy JTF_NUMBER_TABLE
2463 , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2464 , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2465 , p3_a3 in out nocopy JTF_NUMBER_TABLE
2466 , p3_a4 in out nocopy JTF_NUMBER_TABLE
2467 , p3_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2468 , p3_a6 in out nocopy JTF_NUMBER_TABLE
2469 , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_100
2470 , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
2471 , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
2472 , p3_a10 in out nocopy JTF_NUMBER_TABLE
2473 , p3_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2474 , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2475 , p3_a13 in out nocopy JTF_NUMBER_TABLE
2476 , p3_a14 in out nocopy JTF_NUMBER_TABLE
2477 , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
2478 , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
2479 , p3_a17 in out nocopy JTF_VARCHAR2_TABLE_100
2480 , p3_a18 in out nocopy JTF_NUMBER_TABLE
2481 , p3_a19 in out nocopy JTF_VARCHAR2_TABLE_100
2482 , p3_a20 in out nocopy JTF_DATE_TABLE
2483 , p3_a21 in out nocopy JTF_DATE_TABLE
2484 , p3_a22 in out nocopy JTF_VARCHAR2_TABLE_100
2485 , p3_a23 in out nocopy JTF_NUMBER_TABLE
2486 , p3_a24 in out nocopy JTF_NUMBER_TABLE
2487 , p3_a25 in out nocopy JTF_VARCHAR2_TABLE_100
2488 , p3_a26 in out nocopy JTF_NUMBER_TABLE
2489 , p3_a27 in out nocopy JTF_NUMBER_TABLE
2490 , p3_a28 in out nocopy JTF_NUMBER_TABLE
2491 , p3_a29 in out nocopy JTF_NUMBER_TABLE
2492 , p3_a30 in out nocopy JTF_NUMBER_TABLE
2493 , p3_a31 in out nocopy JTF_NUMBER_TABLE
2494 , p3_a32 in out nocopy JTF_NUMBER_TABLE
2495 , p3_a33 in out nocopy JTF_NUMBER_TABLE
2496 , p3_a34 in out nocopy JTF_NUMBER_TABLE
2497 , p3_a35 in out nocopy JTF_VARCHAR2_TABLE_100
2498 , p3_a36 in out nocopy JTF_NUMBER_TABLE
2499 , p3_a37 in out nocopy JTF_NUMBER_TABLE
2500 , p3_a38 in out nocopy JTF_NUMBER_TABLE
2501 , p3_a39 in out nocopy JTF_NUMBER_TABLE
2502 , p3_a40 in out nocopy JTF_DATE_TABLE
2503 , p3_a41 in out nocopy JTF_VARCHAR2_TABLE_100
2504 , p3_a42 in out nocopy JTF_DATE_TABLE
2505 , p3_a43 in out nocopy JTF_DATE_TABLE
2506 , p3_a44 in out nocopy JTF_VARCHAR2_TABLE_100
2507 , p3_a45 in out nocopy JTF_VARCHAR2_TABLE_100
2508 , p3_a46 in out nocopy JTF_VARCHAR2_TABLE_300
2509 , p3_a47 in out nocopy JTF_VARCHAR2_TABLE_300
2510 , p3_a48 in out nocopy JTF_VARCHAR2_TABLE_100
2511 , p3_a49 in out nocopy JTF_VARCHAR2_TABLE_300
2512 , p3_a50 in out nocopy JTF_VARCHAR2_TABLE_300
2513 , p3_a51 in out nocopy JTF_VARCHAR2_TABLE_300
2514 , p3_a52 in out nocopy JTF_VARCHAR2_TABLE_300
2515 , p3_a53 in out nocopy JTF_VARCHAR2_TABLE_300
2516 , p3_a54 in out nocopy JTF_VARCHAR2_TABLE_300
2517 , p3_a55 in out nocopy JTF_VARCHAR2_TABLE_300
2518 , p3_a56 in out nocopy JTF_VARCHAR2_TABLE_300
2519 , p3_a57 in out nocopy JTF_VARCHAR2_TABLE_300
2520 , p3_a58 in out nocopy JTF_VARCHAR2_TABLE_300
2521 , p3_a59 in out nocopy JTF_VARCHAR2_TABLE_300
2522 , p3_a60 in out nocopy JTF_VARCHAR2_TABLE_300
2523 , p3_a61 in out nocopy JTF_VARCHAR2_TABLE_300
2524 , p3_a62 in out nocopy JTF_VARCHAR2_TABLE_300
2525 , p3_a63 in out nocopy JTF_VARCHAR2_TABLE_300
2526 , p3_a64 in out nocopy JTF_NUMBER_TABLE
2527 , p3_a65 in out nocopy JTF_NUMBER_TABLE
2528 , p3_a66 in out nocopy JTF_VARCHAR2_TABLE_100
2529 , p3_a67 in out nocopy JTF_NUMBER_TABLE
2530 , p3_a68 in out nocopy JTF_VARCHAR2_TABLE_100
2531 , p3_a69 in out nocopy JTF_VARCHAR2_TABLE_100
2532 , p3_a70 in out nocopy JTF_VARCHAR2_TABLE_100
2533 , p3_a71 in out nocopy JTF_VARCHAR2_TABLE_100
2534 , p3_a72 in out nocopy JTF_NUMBER_TABLE
2535 , p3_a73 in out nocopy JTF_VARCHAR2_TABLE_100
2536 , p3_a74 in out nocopy JTF_NUMBER_TABLE
2537 , p3_a75 in out nocopy JTF_NUMBER_TABLE
2538 , p3_a76 in out nocopy JTF_NUMBER_TABLE
2539 , p3_a77 in out nocopy JTF_VARCHAR2_TABLE_100
2540 , p3_a78 in out nocopy JTF_VARCHAR2_TABLE_300
2541 , p3_a79 in out nocopy JTF_VARCHAR2_TABLE_100
2542 , p3_a80 in out nocopy JTF_NUMBER_TABLE
2543 , p3_a81 in out nocopy JTF_NUMBER_TABLE
2544 , p3_a82 in out nocopy JTF_NUMBER_TABLE
2545 , p3_a83 in out nocopy JTF_DATE_TABLE
2546 , p3_a84 in out nocopy JTF_VARCHAR2_TABLE_100
2547 , p3_a85 in out nocopy JTF_VARCHAR2_TABLE_100
2548 , p3_a86 in out nocopy JTF_VARCHAR2_TABLE_100
2549 , p3_a87 in out nocopy JTF_NUMBER_TABLE
2550 , p3_a88 in out nocopy JTF_VARCHAR2_TABLE_100
2551 , p3_a89 in out nocopy JTF_NUMBER_TABLE
2552 , p3_a90 in out nocopy JTF_NUMBER_TABLE
2553 , p3_a91 in out nocopy JTF_VARCHAR2_TABLE_100
2554 , p3_a92 in out nocopy JTF_NUMBER_TABLE
2555 , p3_a93 in out nocopy JTF_VARCHAR2_TABLE_100
2556 , p3_a94 in out nocopy JTF_NUMBER_TABLE
2557 , p3_a95 in out nocopy JTF_DATE_TABLE
2558 , p3_a96 in out nocopy JTF_VARCHAR2_TABLE_300
2559 , p3_a97 in out nocopy JTF_VARCHAR2_TABLE_300
2560 , p3_a98 in out nocopy JTF_VARCHAR2_TABLE_300
2561 , p3_a99 in out nocopy JTF_VARCHAR2_TABLE_300
2562 , p3_a100 in out nocopy JTF_VARCHAR2_TABLE_300
2563 , p3_a101 in out nocopy JTF_VARCHAR2_TABLE_300
2564 , p3_a102 in out nocopy JTF_VARCHAR2_TABLE_300
2565 , p3_a103 in out nocopy JTF_VARCHAR2_TABLE_300
2566 , p3_a104 in out nocopy JTF_VARCHAR2_TABLE_300
2567 , p3_a105 in out nocopy JTF_VARCHAR2_TABLE_300
2568 , p3_a106 in out nocopy JTF_VARCHAR2_TABLE_300
2569 , p3_a107 in out nocopy JTF_VARCHAR2_TABLE_300
2570 , p3_a108 in out nocopy JTF_VARCHAR2_TABLE_300
2571 , p3_a109 in out nocopy JTF_VARCHAR2_TABLE_300
2572 , p3_a110 in out nocopy JTF_VARCHAR2_TABLE_300
2573 , p3_a111 in out nocopy JTF_NUMBER_TABLE
2574 , p3_a112 in out nocopy JTF_VARCHAR2_TABLE_100
2575 , p3_a113 in out nocopy JTF_NUMBER_TABLE
2576 , p3_a114 in out nocopy JTF_VARCHAR2_TABLE_100
2577 , p3_a115 in out nocopy JTF_NUMBER_TABLE
2578 , p3_a116 in out nocopy JTF_VARCHAR2_TABLE_100
2579 , p3_a117 in out nocopy JTF_VARCHAR2_TABLE_100
2580 , p3_a118 in out nocopy JTF_NUMBER_TABLE
2581 , p3_a119 in out nocopy JTF_VARCHAR2_TABLE_100
2582 , p3_a120 in out nocopy JTF_NUMBER_TABLE
2583 , p3_a121 in out nocopy JTF_NUMBER_TABLE
2584 , p3_a122 in out nocopy JTF_VARCHAR2_TABLE_100
2585 , p4_a0 in out nocopy JTF_NUMBER_TABLE
2586 , p4_a1 in out nocopy JTF_NUMBER_TABLE
2587 , p4_a2 in out nocopy JTF_NUMBER_TABLE
2588 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2589 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
2590 , p4_a5 in out nocopy JTF_DATE_TABLE
2591 , p4_a6 in out nocopy JTF_DATE_TABLE
2592 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
2593 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_200
2594 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_200
2595 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_200
2596 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
2597 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
2598 , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_200
2599 , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2600 , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2601 , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2602 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2603 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2604 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2605 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2606 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2607 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2608 , p4_a23 in out nocopy JTF_NUMBER_TABLE
2609 , p4_a24 in out nocopy JTF_NUMBER_TABLE
2610 , p5_a0 in out nocopy JTF_NUMBER_TABLE
2611 , p5_a1 in out nocopy JTF_NUMBER_TABLE
2612 , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2613 , p5_a3 in out nocopy JTF_NUMBER_TABLE
2614 , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
2615 , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2616 , p5_a6 in out nocopy JTF_NUMBER_TABLE
2617 , p5_a7 in out nocopy JTF_DATE_TABLE
2618 , p5_a8 in out nocopy JTF_DATE_TABLE
2619 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
2620 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
2621 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
2622 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
2623 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
2624 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2625 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2626 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2627 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2628 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2629 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2630 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2631 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2632 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2633 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2634 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
2635 , p5_a25 in out nocopy JTF_NUMBER_TABLE
2636 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2637 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
2638 , p5_a28 in out nocopy JTF_NUMBER_TABLE
2639 , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
2640 , p5_a30 in out nocopy JTF_NUMBER_TABLE
2641 , p5_a31 in out nocopy JTF_NUMBER_TABLE
2642 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
2643 , p6_a0 in out nocopy JTF_NUMBER_TABLE
2644 , p6_a1 in out nocopy JTF_NUMBER_TABLE
2645 , p6_a2 in out nocopy JTF_NUMBER_TABLE
2646 , p6_a3 in out nocopy JTF_NUMBER_TABLE
2647 , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
2648 , p6_a5 in out nocopy JTF_NUMBER_TABLE
2649 , p6_a6 in out nocopy JTF_NUMBER_TABLE
2650 , p6_a7 in out nocopy JTF_DATE_TABLE
2651 , p6_a8 in out nocopy JTF_DATE_TABLE
2652 , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
2653 , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
2654 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
2655 , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
2656 , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
2657 , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2658 , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2659 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2660 , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2661 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2662 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2663 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2664 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2665 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2666 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2667 , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
2668 , p6_a25 in out nocopy JTF_NUMBER_TABLE
2669 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2670 , p6_a27 in out nocopy JTF_NUMBER_TABLE
2671 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_100
2672 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
2673 , p6_a30 in out nocopy JTF_NUMBER_TABLE
2674 , p6_a31 in out nocopy JTF_NUMBER_TABLE
2675 , p6_a32 in out nocopy JTF_NUMBER_TABLE
2676 , p6_a33 in out nocopy JTF_DATE_TABLE
2677 , p6_a34 in out nocopy JTF_NUMBER_TABLE
2678 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
2679 , p7_a0 in out nocopy NUMBER
2680 , p7_a1 in out nocopy DATE
2681 , p7_a2 in out nocopy DATE
2682 , p7_a3 in out nocopy NUMBER
2683 , p7_a4 in out nocopy NUMBER
2684 , p7_a5 in out nocopy NUMBER
2685 , p7_a6 in out nocopy VARCHAR2
2686 , p7_a7 in out nocopy NUMBER
2687 , p7_a8 in out nocopy VARCHAR2
2688 , p7_a9 in out nocopy NUMBER
2689 , p7_a10 in out nocopy VARCHAR2
2690 , p7_a11 in out nocopy NUMBER
2691 , p7_a12 in out nocopy NUMBER
2692 , p7_a13 in out nocopy NUMBER
2693 , p7_a14 in out nocopy NUMBER
2694 , p7_a15 in out nocopy VARCHAR2
2695 , p7_a16 in out nocopy NUMBER
2696 , p7_a17 in out nocopy VARCHAR2
2697 , p7_a18 in out nocopy VARCHAR2
2698 , p7_a19 in out nocopy NUMBER
2699 , p7_a20 in out nocopy VARCHAR2
2700 , p7_a21 in out nocopy VARCHAR2
2701 , p7_a22 in out nocopy VARCHAR2
2702 , p7_a23 in out nocopy VARCHAR2
2703 , p7_a24 in out nocopy VARCHAR2
2704 , p7_a25 in out nocopy VARCHAR2
2705 , p7_a26 in out nocopy VARCHAR2
2706 , p7_a27 in out nocopy VARCHAR2
2707 , p7_a28 in out nocopy VARCHAR2
2708 , p7_a29 in out nocopy VARCHAR2
2709 , p7_a30 in out nocopy VARCHAR2
2710 , p7_a31 in out nocopy VARCHAR2
2711 , p7_a32 in out nocopy VARCHAR2
2712 , p7_a33 in out nocopy VARCHAR2
2713 , p7_a34 in out nocopy VARCHAR2
2714 , p7_a35 in out nocopy VARCHAR2
2715 , p7_a36 in out nocopy NUMBER
2716 , p7_a37 in out nocopy VARCHAR2
2717 , p7_a38 in out nocopy DATE
2718 , p7_a39 in out nocopy NUMBER
2719 , x_return_status out nocopy VARCHAR2
2720 , x_msg_count out nocopy NUMBER
2721 , x_msg_data out nocopy VARCHAR2
2722 )
2723
2724 as
2725 ddp_instance_tbl csi_datastructures_pub.instance_tbl;
2726 ddp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2727 ddp_party_tbl csi_datastructures_pub.party_tbl;
2728 ddp_account_tbl csi_datastructures_pub.party_account_tbl;
2729 ddp_txn_rec csi_datastructures_pub.transaction_rec;
2730 ddindx binary_integer; indx binary_integer;
2731 begin
2732
2733 -- copy data to the local IN or IN-OUT args, if any
2734
2735
2736
2737 csi_datastructures_pub_w.rosetta_table_copy_in_p19(ddp_instance_tbl, p3_a0
2738 , p3_a1
2739 , p3_a2
2740 , p3_a3
2741 , p3_a4
2742 , p3_a5
2743 , p3_a6
2744 , p3_a7
2745 , p3_a8
2746 , p3_a9
2747 , p3_a10
2748 , p3_a11
2749 , p3_a12
2750 , p3_a13
2751 , p3_a14
2752 , p3_a15
2753 , p3_a16
2754 , p3_a17
2755 , p3_a18
2756 , p3_a19
2757 , p3_a20
2758 , p3_a21
2759 , p3_a22
2760 , p3_a23
2761 , p3_a24
2762 , p3_a25
2763 , p3_a26
2764 , p3_a27
2765 , p3_a28
2766 , p3_a29
2767 , p3_a30
2768 , p3_a31
2769 , p3_a32
2770 , p3_a33
2771 , p3_a34
2772 , p3_a35
2773 , p3_a36
2774 , p3_a37
2775 , p3_a38
2776 , p3_a39
2777 , p3_a40
2778 , p3_a41
2779 , p3_a42
2780 , p3_a43
2781 , p3_a44
2782 , p3_a45
2783 , p3_a46
2784 , p3_a47
2785 , p3_a48
2786 , p3_a49
2787 , p3_a50
2788 , p3_a51
2789 , p3_a52
2790 , p3_a53
2791 , p3_a54
2792 , p3_a55
2793 , p3_a56
2794 , p3_a57
2795 , p3_a58
2796 , p3_a59
2797 , p3_a60
2798 , p3_a61
2799 , p3_a62
2800 , p3_a63
2801 , p3_a64
2802 , p3_a65
2803 , p3_a66
2804 , p3_a67
2805 , p3_a68
2806 , p3_a69
2807 , p3_a70
2808 , p3_a71
2809 , p3_a72
2810 , p3_a73
2811 , p3_a74
2812 , p3_a75
2813 , p3_a76
2814 , p3_a77
2815 , p3_a78
2816 , p3_a79
2817 , p3_a80
2818 , p3_a81
2819 , p3_a82
2820 , p3_a83
2821 , p3_a84
2822 , p3_a85
2823 , p3_a86
2824 , p3_a87
2825 , p3_a88
2826 , p3_a89
2827 , p3_a90
2828 , p3_a91
2829 , p3_a92
2830 , p3_a93
2831 , p3_a94
2832 , p3_a95
2833 , p3_a96
2834 , p3_a97
2835 , p3_a98
2836 , p3_a99
2837 , p3_a100
2838 , p3_a101
2839 , p3_a102
2840 , p3_a103
2841 , p3_a104
2842 , p3_a105
2843 , p3_a106
2844 , p3_a107
2845 , p3_a108
2846 , p3_a109
2847 , p3_a110
2848 , p3_a111
2849 , p3_a112
2850 , p3_a113
2851 , p3_a114
2852 , p3_a115
2853 , p3_a116
2854 , p3_a117
2855 , p3_a118
2856 , p3_a119
2857 , p3_a120
2858 , p3_a121
2859 , p3_a122
2860 );
2861
2862 csi_datastructures_pub_w.rosetta_table_copy_in_p43(ddp_ext_attrib_values_tbl, p4_a0
2863 , p4_a1
2864 , p4_a2
2865 , p4_a3
2866 , p4_a4
2867 , p4_a5
2868 , p4_a6
2869 , p4_a7
2870 , p4_a8
2871 , p4_a9
2872 , p4_a10
2873 , p4_a11
2874 , p4_a12
2875 , p4_a13
2876 , p4_a14
2877 , p4_a15
2878 , p4_a16
2879 , p4_a17
2880 , p4_a18
2881 , p4_a19
2882 , p4_a20
2883 , p4_a21
2884 , p4_a22
2885 , p4_a23
2886 , p4_a24
2887 );
2888
2889 csi_datastructures_pub_w.rosetta_table_copy_in_p9(ddp_party_tbl, p5_a0
2890 , p5_a1
2891 , p5_a2
2892 , p5_a3
2893 , p5_a4
2894 , p5_a5
2895 , p5_a6
2896 , p5_a7
2897 , p5_a8
2898 , p5_a9
2899 , p5_a10
2900 , p5_a11
2901 , p5_a12
2902 , p5_a13
2903 , p5_a14
2904 , p5_a15
2905 , p5_a16
2906 , p5_a17
2907 , p5_a18
2908 , p5_a19
2909 , p5_a20
2910 , p5_a21
2911 , p5_a22
2912 , p5_a23
2913 , p5_a24
2914 , p5_a25
2915 , p5_a26
2916 , p5_a27
2917 , p5_a28
2918 , p5_a29
2919 , p5_a30
2920 , p5_a31
2921 , p5_a32
2922 );
2923
2924 csi_datastructures_pub_w.rosetta_table_copy_in_p6(ddp_account_tbl, p6_a0
2925 , p6_a1
2926 , p6_a2
2927 , p6_a3
2928 , p6_a4
2929 , p6_a5
2930 , p6_a6
2931 , p6_a7
2932 , p6_a8
2933 , p6_a9
2934 , p6_a10
2935 , p6_a11
2936 , p6_a12
2937 , p6_a13
2938 , p6_a14
2939 , p6_a15
2940 , p6_a16
2941 , p6_a17
2942 , p6_a18
2943 , p6_a19
2944 , p6_a20
2945 , p6_a21
2946 , p6_a22
2947 , p6_a23
2948 , p6_a24
2949 , p6_a25
2950 , p6_a26
2951 , p6_a27
2952 , p6_a28
2953 , p6_a29
2954 , p6_a30
2955 , p6_a31
2956 , p6_a32
2957 , p6_a33
2958 , p6_a34
2959 , p6_a35
2960 );
2961
2962 ddp_txn_rec.transaction_id := rosetta_g_miss_num_map(p7_a0);
2963 ddp_txn_rec.transaction_date := rosetta_g_miss_date_in_map(p7_a1);
2964 ddp_txn_rec.source_transaction_date := rosetta_g_miss_date_in_map(p7_a2);
2965 ddp_txn_rec.transaction_type_id := rosetta_g_miss_num_map(p7_a3);
2966 ddp_txn_rec.txn_sub_type_id := rosetta_g_miss_num_map(p7_a4);
2967 ddp_txn_rec.source_group_ref_id := rosetta_g_miss_num_map(p7_a5);
2968 ddp_txn_rec.source_group_ref := p7_a6;
2969 ddp_txn_rec.source_header_ref_id := rosetta_g_miss_num_map(p7_a7);
2970 ddp_txn_rec.source_header_ref := p7_a8;
2971 ddp_txn_rec.source_line_ref_id := rosetta_g_miss_num_map(p7_a9);
2972 ddp_txn_rec.source_line_ref := p7_a10;
2973 ddp_txn_rec.source_dist_ref_id1 := rosetta_g_miss_num_map(p7_a11);
2974 ddp_txn_rec.source_dist_ref_id2 := rosetta_g_miss_num_map(p7_a12);
2975 ddp_txn_rec.inv_material_transaction_id := rosetta_g_miss_num_map(p7_a13);
2976 ddp_txn_rec.transaction_quantity := rosetta_g_miss_num_map(p7_a14);
2977 ddp_txn_rec.transaction_uom_code := p7_a15;
2978 ddp_txn_rec.transacted_by := rosetta_g_miss_num_map(p7_a16);
2979 ddp_txn_rec.transaction_status_code := p7_a17;
2980 ddp_txn_rec.transaction_action_code := p7_a18;
2981 ddp_txn_rec.message_id := rosetta_g_miss_num_map(p7_a19);
2982 ddp_txn_rec.context := p7_a20;
2983 ddp_txn_rec.attribute1 := p7_a21;
2984 ddp_txn_rec.attribute2 := p7_a22;
2985 ddp_txn_rec.attribute3 := p7_a23;
2986 ddp_txn_rec.attribute4 := p7_a24;
2987 ddp_txn_rec.attribute5 := p7_a25;
2988 ddp_txn_rec.attribute6 := p7_a26;
2989 ddp_txn_rec.attribute7 := p7_a27;
2990 ddp_txn_rec.attribute8 := p7_a28;
2991 ddp_txn_rec.attribute9 := p7_a29;
2992 ddp_txn_rec.attribute10 := p7_a30;
2993 ddp_txn_rec.attribute11 := p7_a31;
2994 ddp_txn_rec.attribute12 := p7_a32;
2995 ddp_txn_rec.attribute13 := p7_a33;
2996 ddp_txn_rec.attribute14 := p7_a34;
2997 ddp_txn_rec.attribute15 := p7_a35;
2998 ddp_txn_rec.object_version_number := rosetta_g_miss_num_map(p7_a36);
2999 ddp_txn_rec.split_reason_code := p7_a37;
3000 ddp_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p7_a38);
3001 ddp_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p7_a39);
3002
3003
3004
3005
3006 -- here's the delegated call to the old PL/SQL routine
3007 csi_mass_edit_pub.process_system_mass_update(p_api_version,
3008 p_commit,
3009 p_entry_id,
3010 ddp_instance_tbl,
3011 ddp_ext_attrib_values_tbl,
3012 ddp_party_tbl,
3013 ddp_account_tbl,
3014 ddp_txn_rec,
3015 x_return_status,
3016 x_msg_count,
3017 x_msg_data);
3018
3019 -- copy data back from the local variables to OUT or IN-OUT args, if any
3020
3021
3022
3023 csi_datastructures_pub_w.rosetta_table_copy_out_p19(ddp_instance_tbl, p3_a0
3024 , p3_a1
3025 , p3_a2
3026 , p3_a3
3027 , p3_a4
3028 , p3_a5
3029 , p3_a6
3030 , p3_a7
3031 , p3_a8
3032 , p3_a9
3033 , p3_a10
3034 , p3_a11
3035 , p3_a12
3036 , p3_a13
3037 , p3_a14
3038 , p3_a15
3039 , p3_a16
3040 , p3_a17
3041 , p3_a18
3042 , p3_a19
3043 , p3_a20
3044 , p3_a21
3045 , p3_a22
3046 , p3_a23
3047 , p3_a24
3048 , p3_a25
3049 , p3_a26
3050 , p3_a27
3051 , p3_a28
3052 , p3_a29
3053 , p3_a30
3054 , p3_a31
3055 , p3_a32
3056 , p3_a33
3057 , p3_a34
3058 , p3_a35
3059 , p3_a36
3060 , p3_a37
3061 , p3_a38
3062 , p3_a39
3063 , p3_a40
3064 , p3_a41
3065 , p3_a42
3066 , p3_a43
3067 , p3_a44
3068 , p3_a45
3069 , p3_a46
3070 , p3_a47
3071 , p3_a48
3072 , p3_a49
3073 , p3_a50
3074 , p3_a51
3075 , p3_a52
3076 , p3_a53
3077 , p3_a54
3078 , p3_a55
3079 , p3_a56
3080 , p3_a57
3081 , p3_a58
3082 , p3_a59
3083 , p3_a60
3084 , p3_a61
3085 , p3_a62
3086 , p3_a63
3087 , p3_a64
3088 , p3_a65
3089 , p3_a66
3090 , p3_a67
3091 , p3_a68
3092 , p3_a69
3093 , p3_a70
3094 , p3_a71
3095 , p3_a72
3096 , p3_a73
3097 , p3_a74
3098 , p3_a75
3099 , p3_a76
3100 , p3_a77
3101 , p3_a78
3102 , p3_a79
3103 , p3_a80
3104 , p3_a81
3105 , p3_a82
3106 , p3_a83
3107 , p3_a84
3108 , p3_a85
3109 , p3_a86
3110 , p3_a87
3111 , p3_a88
3112 , p3_a89
3113 , p3_a90
3114 , p3_a91
3115 , p3_a92
3116 , p3_a93
3117 , p3_a94
3118 , p3_a95
3119 , p3_a96
3120 , p3_a97
3121 , p3_a98
3122 , p3_a99
3123 , p3_a100
3124 , p3_a101
3125 , p3_a102
3126 , p3_a103
3127 , p3_a104
3128 , p3_a105
3129 , p3_a106
3130 , p3_a107
3131 , p3_a108
3132 , p3_a109
3133 , p3_a110
3134 , p3_a111
3135 , p3_a112
3136 , p3_a113
3137 , p3_a114
3138 , p3_a115
3139 , p3_a116
3140 , p3_a117
3141 , p3_a118
3142 , p3_a119
3143 , p3_a120
3144 , p3_a121
3145 , p3_a122
3146 );
3147
3148 csi_datastructures_pub_w.rosetta_table_copy_out_p43(ddp_ext_attrib_values_tbl, p4_a0
3149 , p4_a1
3150 , p4_a2
3151 , p4_a3
3152 , p4_a4
3153 , p4_a5
3154 , p4_a6
3155 , p4_a7
3156 , p4_a8
3157 , p4_a9
3158 , p4_a10
3159 , p4_a11
3160 , p4_a12
3161 , p4_a13
3162 , p4_a14
3163 , p4_a15
3164 , p4_a16
3165 , p4_a17
3166 , p4_a18
3167 , p4_a19
3168 , p4_a20
3169 , p4_a21
3170 , p4_a22
3171 , p4_a23
3172 , p4_a24
3173 );
3174
3175 csi_datastructures_pub_w.rosetta_table_copy_out_p9(ddp_party_tbl, p5_a0
3176 , p5_a1
3177 , p5_a2
3178 , p5_a3
3179 , p5_a4
3180 , p5_a5
3181 , p5_a6
3182 , p5_a7
3183 , p5_a8
3184 , p5_a9
3185 , p5_a10
3186 , p5_a11
3187 , p5_a12
3188 , p5_a13
3189 , p5_a14
3190 , p5_a15
3191 , p5_a16
3192 , p5_a17
3193 , p5_a18
3194 , p5_a19
3195 , p5_a20
3196 , p5_a21
3197 , p5_a22
3198 , p5_a23
3199 , p5_a24
3200 , p5_a25
3201 , p5_a26
3202 , p5_a27
3203 , p5_a28
3204 , p5_a29
3205 , p5_a30
3206 , p5_a31
3207 , p5_a32
3208 );
3209
3210 csi_datastructures_pub_w.rosetta_table_copy_out_p6(ddp_account_tbl, p6_a0
3211 , p6_a1
3212 , p6_a2
3213 , p6_a3
3214 , p6_a4
3215 , p6_a5
3216 , p6_a6
3217 , p6_a7
3218 , p6_a8
3219 , p6_a9
3220 , p6_a10
3221 , p6_a11
3222 , p6_a12
3223 , p6_a13
3224 , p6_a14
3225 , p6_a15
3226 , p6_a16
3227 , p6_a17
3228 , p6_a18
3229 , p6_a19
3230 , p6_a20
3231 , p6_a21
3232 , p6_a22
3233 , p6_a23
3234 , p6_a24
3235 , p6_a25
3236 , p6_a26
3237 , p6_a27
3238 , p6_a28
3239 , p6_a29
3240 , p6_a30
3241 , p6_a31
3242 , p6_a32
3243 , p6_a33
3244 , p6_a34
3245 , p6_a35
3246 );
3247
3248 p7_a0 := rosetta_g_miss_num_map(ddp_txn_rec.transaction_id);
3249 p7_a1 := ddp_txn_rec.transaction_date;
3250 p7_a2 := ddp_txn_rec.source_transaction_date;
3251 p7_a3 := rosetta_g_miss_num_map(ddp_txn_rec.transaction_type_id);
3252 p7_a4 := rosetta_g_miss_num_map(ddp_txn_rec.txn_sub_type_id);
3253 p7_a5 := rosetta_g_miss_num_map(ddp_txn_rec.source_group_ref_id);
3254 p7_a6 := ddp_txn_rec.source_group_ref;
3255 p7_a7 := rosetta_g_miss_num_map(ddp_txn_rec.source_header_ref_id);
3256 p7_a8 := ddp_txn_rec.source_header_ref;
3257 p7_a9 := rosetta_g_miss_num_map(ddp_txn_rec.source_line_ref_id);
3258 p7_a10 := ddp_txn_rec.source_line_ref;
3259 p7_a11 := rosetta_g_miss_num_map(ddp_txn_rec.source_dist_ref_id1);
3260 p7_a12 := rosetta_g_miss_num_map(ddp_txn_rec.source_dist_ref_id2);
3261 p7_a13 := rosetta_g_miss_num_map(ddp_txn_rec.inv_material_transaction_id);
3262 p7_a14 := rosetta_g_miss_num_map(ddp_txn_rec.transaction_quantity);
3263 p7_a15 := ddp_txn_rec.transaction_uom_code;
3264 p7_a16 := rosetta_g_miss_num_map(ddp_txn_rec.transacted_by);
3265 p7_a17 := ddp_txn_rec.transaction_status_code;
3266 p7_a18 := ddp_txn_rec.transaction_action_code;
3267 p7_a19 := rosetta_g_miss_num_map(ddp_txn_rec.message_id);
3268 p7_a20 := ddp_txn_rec.context;
3269 p7_a21 := ddp_txn_rec.attribute1;
3270 p7_a22 := ddp_txn_rec.attribute2;
3271 p7_a23 := ddp_txn_rec.attribute3;
3272 p7_a24 := ddp_txn_rec.attribute4;
3273 p7_a25 := ddp_txn_rec.attribute5;
3274 p7_a26 := ddp_txn_rec.attribute6;
3275 p7_a27 := ddp_txn_rec.attribute7;
3276 p7_a28 := ddp_txn_rec.attribute8;
3277 p7_a29 := ddp_txn_rec.attribute9;
3278 p7_a30 := ddp_txn_rec.attribute10;
3279 p7_a31 := ddp_txn_rec.attribute11;
3280 p7_a32 := ddp_txn_rec.attribute12;
3281 p7_a33 := ddp_txn_rec.attribute13;
3282 p7_a34 := ddp_txn_rec.attribute14;
3283 p7_a35 := ddp_txn_rec.attribute15;
3284 p7_a36 := rosetta_g_miss_num_map(ddp_txn_rec.object_version_number);
3285 p7_a37 := ddp_txn_rec.split_reason_code;
3286 p7_a38 := ddp_txn_rec.src_txn_creation_date;
3287 p7_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
3288
3289
3290
3291 end;
3292
3293 procedure identify_system_for_update(p_txn_line_id NUMBER
3294 , p1_a0 out nocopy JTF_NUMBER_TABLE
3295 , x_return_status out nocopy VARCHAR2
3296 )
3297
3298 as
3299 ddp_upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
3300 ddindx binary_integer; indx binary_integer;
3301 begin
3302
3303 -- copy data to the local IN or IN-OUT args, if any
3304
3305
3306
3307 -- here's the delegated call to the old PL/SQL routine
3308 csi_mass_edit_pub.identify_system_for_update(p_txn_line_id,
3309 ddp_upd_system_tbl,
3310 x_return_status);
3311
3312 -- copy data back from the local variables to OUT or IN-OUT args, if any
3313
3314 csi_datastructures_pub_w.rosetta_table_copy_out_p94(ddp_upd_system_tbl, p1_a0
3315 );
3316
3317 end;
3318
3319 procedure validate_system_batch(p_entry_id NUMBER
3320 , p_txn_line_id NUMBER
3321 , p2_a0 JTF_NUMBER_TABLE
3322 , x_return_status out nocopy VARCHAR2
3323 )
3324
3325 as
3326 ddp_upd_system_tbl csi_datastructures_pub.mu_systems_tbl;
3327 ddindx binary_integer; indx binary_integer;
3328 begin
3329
3330 -- copy data to the local IN or IN-OUT args, if any
3331
3332
3333 csi_datastructures_pub_w.rosetta_table_copy_in_p94(ddp_upd_system_tbl, p2_a0
3334 );
3335
3336
3337 -- here's the delegated call to the old PL/SQL routine
3338 csi_mass_edit_pub.validate_system_batch(p_entry_id,
3339 p_txn_line_id,
3340 ddp_upd_system_tbl,
3341 x_return_status);
3342
3343 -- copy data back from the local variables to OUT or IN-OUT args, if any
3344
3345
3346
3347 end;
3348
3349 end csi_mass_edit_pub_w;