1 package csi_mass_edit_pub_w AUTHID CURRENT_USER as
2 /* $Header: csipmews.pls 120.5.12010000.3 2008/12/03 08:32:30 ngoutam ship $ */
3 procedure rosetta_table_copy_in_p4(t out nocopy csi_mass_edit_pub.mass_edit_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_2000
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 );
16 procedure rosetta_table_copy_out_p4(t csi_mass_edit_pub.mass_edit_tbl, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_VARCHAR2_TABLE_100
18 , a2 out nocopy JTF_NUMBER_TABLE
19 , a3 out nocopy JTF_NUMBER_TABLE
20 , a4 out nocopy JTF_VARCHAR2_TABLE_100
21 , a5 out nocopy JTF_VARCHAR2_TABLE_100
22 , a6 out nocopy JTF_VARCHAR2_TABLE_2000
23 , a7 out nocopy JTF_DATE_TABLE
24 , a8 out nocopy JTF_DATE_TABLE
25 , a9 out nocopy JTF_DATE_TABLE
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_VARCHAR2_TABLE_100
28 );
29
30 procedure rosetta_table_copy_in_p6(t out nocopy csi_mass_edit_pub.mass_edit_inst_tbl, a0 JTF_NUMBER_TABLE
31 , a1 JTF_NUMBER_TABLE
32 , a2 JTF_DATE_TABLE
33 , a3 JTF_NUMBER_TABLE
34 );
35 procedure rosetta_table_copy_out_p6(t csi_mass_edit_pub.mass_edit_inst_tbl, a0 out nocopy JTF_NUMBER_TABLE
36 , a1 out nocopy JTF_NUMBER_TABLE
37 , a2 out nocopy JTF_DATE_TABLE
38 , a3 out nocopy JTF_NUMBER_TABLE
39 );
40
41 procedure rosetta_table_copy_in_p8(t out nocopy csi_mass_edit_pub.mass_edit_error_tbl, a0 JTF_NUMBER_TABLE
42 , a1 JTF_NUMBER_TABLE
43 , a2 JTF_NUMBER_TABLE
44 , a3 JTF_VARCHAR2_TABLE_2000
45 , a4 JTF_VARCHAR2_TABLE_100
46 , a5 JTF_VARCHAR2_TABLE_100
47 );
48 procedure rosetta_table_copy_out_p8(t csi_mass_edit_pub.mass_edit_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
49 , a1 out nocopy JTF_NUMBER_TABLE
50 , a2 out nocopy JTF_NUMBER_TABLE
51 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
52 , a4 out nocopy JTF_VARCHAR2_TABLE_100
53 , a5 out nocopy JTF_VARCHAR2_TABLE_100
54 );
55
56 procedure rosetta_table_copy_in_p10(t out nocopy csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 JTF_NUMBER_TABLE
57 , a1 JTF_VARCHAR2_TABLE_100
58 , a2 JTF_NUMBER_TABLE
59 , a3 JTF_NUMBER_TABLE
60 , a4 JTF_VARCHAR2_TABLE_2000
61 , a5 JTF_VARCHAR2_TABLE_100
62 , a6 JTF_VARCHAR2_TABLE_100
63 );
64 procedure rosetta_table_copy_out_p10(t csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_VARCHAR2_TABLE_100
66 , a2 out nocopy JTF_NUMBER_TABLE
67 , a3 out nocopy JTF_NUMBER_TABLE
68 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
69 , a5 out nocopy JTF_VARCHAR2_TABLE_100
70 , a6 out nocopy JTF_VARCHAR2_TABLE_100
71 );
72
73 procedure rosetta_table_copy_in_p12(t out nocopy csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 JTF_NUMBER_TABLE
74 , a1 JTF_VARCHAR2_TABLE_100
75 , a2 JTF_VARCHAR2_TABLE_2000
76 , a3 JTF_NUMBER_TABLE
77 , a4 JTF_NUMBER_TABLE
78 , a5 JTF_VARCHAR2_TABLE_100
79 , a6 JTF_VARCHAR2_TABLE_100
80 );
81 procedure rosetta_table_copy_out_p12(t csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
82 , a1 out nocopy JTF_VARCHAR2_TABLE_100
83 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
84 , a3 out nocopy JTF_NUMBER_TABLE
85 , a4 out nocopy JTF_NUMBER_TABLE
86 , a5 out nocopy JTF_VARCHAR2_TABLE_100
87 , a6 out nocopy JTF_VARCHAR2_TABLE_100
88 );
89
90 procedure create_mass_edit_batch(p_api_version NUMBER
91 , p_commit VARCHAR2
92 , p_init_msg_list VARCHAR2
93 , p_validation_level NUMBER
94 , p4_a0 in out nocopy NUMBER
95 , p4_a1 in out nocopy VARCHAR2
96 , p4_a2 in out nocopy NUMBER
97 , p4_a3 in out nocopy NUMBER
98 , p4_a4 in out nocopy VARCHAR2
99 , p4_a5 in out nocopy VARCHAR2
100 , p4_a6 in out nocopy VARCHAR2
101 , p4_a7 in out nocopy DATE
102 , p4_a8 in out nocopy DATE
103 , p4_a9 in out nocopy DATE
104 , p4_a10 in out nocopy NUMBER
105 , p4_a11 in out nocopy VARCHAR2
106 , p5_a0 in out nocopy NUMBER
107 , p5_a1 in out nocopy NUMBER
108 , p5_a2 in out nocopy NUMBER
109 , p5_a3 in out nocopy NUMBER
110 , p5_a4 in out nocopy VARCHAR2
111 , p5_a5 in out nocopy NUMBER
112 , p5_a6 in out nocopy NUMBER
113 , p5_a7 in out nocopy NUMBER
114 , p5_a8 in out nocopy VARCHAR2
115 , p5_a9 in out nocopy VARCHAR2
116 , p5_a10 in out nocopy VARCHAR2
117 , p5_a11 in out nocopy VARCHAR2
118 , p5_a12 in out nocopy VARCHAR2
119 , p5_a13 in out nocopy VARCHAR2
120 , p5_a14 in out nocopy VARCHAR2
121 , p5_a15 in out nocopy VARCHAR2
122 , p5_a16 in out nocopy VARCHAR2
123 , p5_a17 in out nocopy VARCHAR2
124 , p5_a18 in out nocopy VARCHAR2
125 , p5_a19 in out nocopy VARCHAR2
126 , p5_a20 in out nocopy VARCHAR2
127 , p5_a21 in out nocopy VARCHAR2
128 , p5_a22 in out nocopy VARCHAR2
129 , p5_a23 in out nocopy VARCHAR2
130 , p5_a24 in out nocopy VARCHAR2
131 , p5_a25 in out nocopy VARCHAR2
132 , p5_a26 in out nocopy VARCHAR2
133 , p5_a27 in out nocopy VARCHAR2
134 , p5_a28 in out nocopy VARCHAR2
135 , p5_a29 in out nocopy VARCHAR2
136 , p5_a30 in out nocopy VARCHAR2
137 , p5_a31 in out nocopy NUMBER
138 , p6_a0 in out nocopy JTF_NUMBER_TABLE
139 , p6_a1 in out nocopy JTF_NUMBER_TABLE
140 , p6_a2 in out nocopy JTF_DATE_TABLE
141 , p6_a3 in out nocopy JTF_NUMBER_TABLE
142 , p7_a0 in out nocopy NUMBER
143 , p7_a1 in out nocopy NUMBER
144 , p7_a2 in out nocopy NUMBER
145 , p7_a3 in out nocopy VARCHAR2
146 , p7_a4 in out nocopy VARCHAR2
147 , p7_a5 in out nocopy NUMBER
148 , p7_a6 in out nocopy NUMBER
149 , p7_a7 in out nocopy NUMBER
150 , p7_a8 in out nocopy NUMBER
151 , p7_a9 in out nocopy VARCHAR2
152 , p7_a10 in out nocopy NUMBER
153 , p7_a11 in out nocopy NUMBER
154 , p7_a12 in out nocopy VARCHAR2
155 , p7_a13 in out nocopy NUMBER
156 , p7_a14 in out nocopy VARCHAR2
157 , p7_a15 in out nocopy NUMBER
158 , p7_a16 in out nocopy VARCHAR2
159 , p7_a17 in out nocopy VARCHAR2
160 , p7_a18 in out nocopy VARCHAR2
161 , p7_a19 in out nocopy VARCHAR2
162 , p7_a20 in out nocopy NUMBER
163 , p7_a21 in out nocopy DATE
164 , p7_a22 in out nocopy DATE
165 , p7_a23 in out nocopy VARCHAR2
166 , p7_a24 in out nocopy NUMBER
167 , p7_a25 in out nocopy VARCHAR2
168 , p7_a26 in out nocopy VARCHAR2
169 , p7_a27 in out nocopy DATE
170 , p7_a28 in out nocopy DATE
171 , p7_a29 in out nocopy DATE
172 , p7_a30 in out nocopy VARCHAR2
173 , p7_a31 in out nocopy NUMBER
174 , p7_a32 in out nocopy NUMBER
175 , p7_a33 in out nocopy DATE
176 , p7_a34 in out nocopy NUMBER
177 , p7_a35 in out nocopy NUMBER
178 , p7_a36 in out nocopy NUMBER
179 , p7_a37 in out nocopy VARCHAR2
180 , p7_a38 in out nocopy VARCHAR2
181 , p7_a39 in out nocopy VARCHAR2
182 , p7_a40 in out nocopy NUMBER
183 , p7_a41 in out nocopy NUMBER
184 , p7_a42 in out nocopy NUMBER
185 , p7_a43 in out nocopy NUMBER
186 , p7_a44 in out nocopy NUMBER
187 , p7_a45 in out nocopy DATE
188 , p7_a46 in out nocopy VARCHAR2
189 , p7_a47 in out nocopy VARCHAR2
190 , p7_a48 in out nocopy VARCHAR2
191 , p7_a49 in out nocopy NUMBER
192 , p7_a50 in out nocopy VARCHAR2
193 , p7_a51 in out nocopy VARCHAR2
194 , p7_a52 in out nocopy VARCHAR2
195 , p7_a53 in out nocopy VARCHAR2
196 , p7_a54 in out nocopy VARCHAR2
197 , p7_a55 in out nocopy VARCHAR2
198 , p7_a56 in out nocopy VARCHAR2
199 , p7_a57 in out nocopy VARCHAR2
200 , p7_a58 in out nocopy VARCHAR2
201 , p7_a59 in out nocopy VARCHAR2
202 , p7_a60 in out nocopy VARCHAR2
203 , p7_a61 in out nocopy VARCHAR2
204 , p7_a62 in out nocopy VARCHAR2
205 , p7_a63 in out nocopy VARCHAR2
206 , p7_a64 in out nocopy VARCHAR2
207 , p7_a65 in out nocopy VARCHAR2
208 , p7_a66 in out nocopy VARCHAR2
209 , p7_a67 in out nocopy NUMBER
210 , p7_a68 in out nocopy NUMBER
211 , p7_a69 in out nocopy NUMBER
212 , p7_a70 in out nocopy NUMBER
213 , p7_a71 in out nocopy NUMBER
214 , p8_a0 in out nocopy JTF_NUMBER_TABLE
215 , p8_a1 in out nocopy JTF_NUMBER_TABLE
216 , p8_a2 in out nocopy JTF_NUMBER_TABLE
217 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
218 , p8_a4 in out nocopy JTF_NUMBER_TABLE
219 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
220 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
221 , p8_a7 in out nocopy JTF_NUMBER_TABLE
222 , p8_a8 in out nocopy JTF_DATE_TABLE
223 , p8_a9 in out nocopy JTF_DATE_TABLE
224 , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
225 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
226 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
227 , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
228 , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
229 , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
230 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
231 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
232 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
233 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
234 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
235 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
236 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
237 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
238 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
239 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
240 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
241 , p8_a27 in out nocopy JTF_NUMBER_TABLE
242 , p8_a28 in out nocopy JTF_NUMBER_TABLE
243 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_100
244 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
245 , p8_a31 in out nocopy JTF_NUMBER_TABLE
246 , p9_a0 in out nocopy JTF_NUMBER_TABLE
247 , p9_a1 in out nocopy JTF_NUMBER_TABLE
248 , p9_a2 in out nocopy JTF_NUMBER_TABLE
249 , p9_a3 in out nocopy JTF_NUMBER_TABLE
250 , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
251 , p9_a5 in out nocopy JTF_NUMBER_TABLE
252 , p9_a6 in out nocopy JTF_NUMBER_TABLE
253 , p9_a7 in out nocopy JTF_DATE_TABLE
254 , p9_a8 in out nocopy JTF_DATE_TABLE
255 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
256 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
257 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
258 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
259 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
260 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
261 , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
262 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
263 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
264 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
265 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
266 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
267 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
268 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
269 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
270 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
271 , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
272 , p9_a26 in out nocopy JTF_NUMBER_TABLE
273 , p9_a27 in out nocopy JTF_NUMBER_TABLE
274 , p10_a0 in out nocopy JTF_NUMBER_TABLE
275 , p10_a1 in out nocopy JTF_NUMBER_TABLE
276 , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
277 , p10_a3 in out nocopy JTF_NUMBER_TABLE
278 , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_300
279 , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
280 , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
281 , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
282 , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
283 , p10_a9 in out nocopy JTF_DATE_TABLE
284 , p10_a10 in out nocopy JTF_DATE_TABLE
285 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
286 , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
287 , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
288 , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
289 , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
290 , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
291 , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
292 , p10_a18 in out nocopy JTF_VARCHAR2_TABLE_200
293 , p10_a19 in out nocopy JTF_VARCHAR2_TABLE_200
294 , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_200
295 , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
296 , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
297 , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
298 , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
299 , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
300 , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
301 , p10_a27 in out nocopy JTF_VARCHAR2_TABLE_200
302 , p10_a28 in out nocopy JTF_NUMBER_TABLE
303 , p10_a29 in out nocopy JTF_NUMBER_TABLE
304 , p11_a0 out nocopy JTF_NUMBER_TABLE
305 , p11_a1 out nocopy JTF_NUMBER_TABLE
306 , p11_a2 out nocopy JTF_NUMBER_TABLE
307 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
308 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
309 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
310 , x_return_status out nocopy VARCHAR2
311 , x_msg_count out nocopy NUMBER
312 , x_msg_data out nocopy VARCHAR2
313 );
314 procedure update_mass_edit_batch(p_api_version NUMBER
315 , p_commit VARCHAR2
316 , p_init_msg_list VARCHAR2
317 , p_validation_level NUMBER
318 , p4_a0 in out nocopy NUMBER
319 , p4_a1 in out nocopy VARCHAR2
320 , p4_a2 in out nocopy NUMBER
321 , p4_a3 in out nocopy NUMBER
322 , p4_a4 in out nocopy VARCHAR2
323 , p4_a5 in out nocopy VARCHAR2
324 , p4_a6 in out nocopy VARCHAR2
325 , p4_a7 in out nocopy DATE
326 , p4_a8 in out nocopy DATE
327 , p4_a9 in out nocopy DATE
328 , p4_a10 in out nocopy NUMBER
329 , p4_a11 in out nocopy VARCHAR2
330 , p5_a0 in out nocopy NUMBER
331 , p5_a1 in out nocopy NUMBER
332 , p5_a2 in out nocopy NUMBER
333 , p5_a3 in out nocopy NUMBER
334 , p5_a4 in out nocopy VARCHAR2
335 , p5_a5 in out nocopy NUMBER
336 , p5_a6 in out nocopy NUMBER
337 , p5_a7 in out nocopy NUMBER
338 , p5_a8 in out nocopy VARCHAR2
339 , p5_a9 in out nocopy VARCHAR2
340 , p5_a10 in out nocopy VARCHAR2
341 , p5_a11 in out nocopy VARCHAR2
342 , p5_a12 in out nocopy VARCHAR2
343 , p5_a13 in out nocopy VARCHAR2
344 , p5_a14 in out nocopy VARCHAR2
345 , p5_a15 in out nocopy VARCHAR2
346 , p5_a16 in out nocopy VARCHAR2
347 , p5_a17 in out nocopy VARCHAR2
348 , p5_a18 in out nocopy VARCHAR2
349 , p5_a19 in out nocopy VARCHAR2
350 , p5_a20 in out nocopy VARCHAR2
351 , p5_a21 in out nocopy VARCHAR2
352 , p5_a22 in out nocopy VARCHAR2
353 , p5_a23 in out nocopy VARCHAR2
354 , p5_a24 in out nocopy VARCHAR2
355 , p5_a25 in out nocopy VARCHAR2
356 , p5_a26 in out nocopy VARCHAR2
357 , p5_a27 in out nocopy VARCHAR2
358 , p5_a28 in out nocopy VARCHAR2
359 , p5_a29 in out nocopy VARCHAR2
360 , p5_a30 in out nocopy VARCHAR2
361 , p5_a31 in out nocopy NUMBER
362 , p6_a0 in out nocopy JTF_NUMBER_TABLE
363 , p6_a1 in out nocopy JTF_NUMBER_TABLE
364 , p6_a2 in out nocopy JTF_DATE_TABLE
365 , p6_a3 in out nocopy JTF_NUMBER_TABLE
366 , p7_a0 in out nocopy NUMBER
367 , p7_a1 in out nocopy NUMBER
368 , p7_a2 in out nocopy NUMBER
369 , p7_a3 in out nocopy VARCHAR2
370 , p7_a4 in out nocopy VARCHAR2
371 , p7_a5 in out nocopy NUMBER
372 , p7_a6 in out nocopy NUMBER
373 , p7_a7 in out nocopy NUMBER
374 , p7_a8 in out nocopy NUMBER
375 , p7_a9 in out nocopy VARCHAR2
376 , p7_a10 in out nocopy NUMBER
377 , p7_a11 in out nocopy NUMBER
378 , p7_a12 in out nocopy VARCHAR2
379 , p7_a13 in out nocopy NUMBER
380 , p7_a14 in out nocopy VARCHAR2
381 , p7_a15 in out nocopy NUMBER
382 , p7_a16 in out nocopy VARCHAR2
383 , p7_a17 in out nocopy VARCHAR2
384 , p7_a18 in out nocopy VARCHAR2
385 , p7_a19 in out nocopy VARCHAR2
386 , p7_a20 in out nocopy NUMBER
387 , p7_a21 in out nocopy DATE
388 , p7_a22 in out nocopy DATE
389 , p7_a23 in out nocopy VARCHAR2
390 , p7_a24 in out nocopy NUMBER
391 , p7_a25 in out nocopy VARCHAR2
392 , p7_a26 in out nocopy VARCHAR2
393 , p7_a27 in out nocopy DATE
394 , p7_a28 in out nocopy DATE
395 , p7_a29 in out nocopy DATE
396 , p7_a30 in out nocopy VARCHAR2
397 , p7_a31 in out nocopy NUMBER
398 , p7_a32 in out nocopy NUMBER
399 , p7_a33 in out nocopy DATE
400 , p7_a34 in out nocopy NUMBER
401 , p7_a35 in out nocopy NUMBER
402 , p7_a36 in out nocopy NUMBER
403 , p7_a37 in out nocopy VARCHAR2
404 , p7_a38 in out nocopy VARCHAR2
405 , p7_a39 in out nocopy VARCHAR2
406 , p7_a40 in out nocopy NUMBER
407 , p7_a41 in out nocopy NUMBER
408 , p7_a42 in out nocopy NUMBER
409 , p7_a43 in out nocopy NUMBER
410 , p7_a44 in out nocopy NUMBER
411 , p7_a45 in out nocopy DATE
412 , p7_a46 in out nocopy VARCHAR2
413 , p7_a47 in out nocopy VARCHAR2
414 , p7_a48 in out nocopy VARCHAR2
415 , p7_a49 in out nocopy NUMBER
416 , p7_a50 in out nocopy VARCHAR2
417 , p7_a51 in out nocopy VARCHAR2
418 , p7_a52 in out nocopy VARCHAR2
419 , p7_a53 in out nocopy VARCHAR2
420 , p7_a54 in out nocopy VARCHAR2
421 , p7_a55 in out nocopy VARCHAR2
422 , p7_a56 in out nocopy VARCHAR2
423 , p7_a57 in out nocopy VARCHAR2
424 , p7_a58 in out nocopy VARCHAR2
425 , p7_a59 in out nocopy VARCHAR2
426 , p7_a60 in out nocopy VARCHAR2
427 , p7_a61 in out nocopy VARCHAR2
428 , p7_a62 in out nocopy VARCHAR2
429 , p7_a63 in out nocopy VARCHAR2
430 , p7_a64 in out nocopy VARCHAR2
431 , p7_a65 in out nocopy VARCHAR2
432 , p7_a66 in out nocopy VARCHAR2
433 , p7_a67 in out nocopy NUMBER
434 , p7_a68 in out nocopy NUMBER
435 , p7_a69 in out nocopy NUMBER
436 , p7_a70 in out nocopy NUMBER
437 , p7_a71 in out nocopy NUMBER
438 , p8_a0 in out nocopy JTF_NUMBER_TABLE
439 , p8_a1 in out nocopy JTF_NUMBER_TABLE
440 , p8_a2 in out nocopy JTF_NUMBER_TABLE
441 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
442 , p8_a4 in out nocopy JTF_NUMBER_TABLE
443 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
444 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
445 , p8_a7 in out nocopy JTF_NUMBER_TABLE
446 , p8_a8 in out nocopy JTF_DATE_TABLE
447 , p8_a9 in out nocopy JTF_DATE_TABLE
448 , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
449 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
450 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
451 , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
452 , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
453 , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
454 , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
455 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
456 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
457 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
458 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
459 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
460 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
461 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
462 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
463 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
464 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
465 , p8_a27 in out nocopy JTF_NUMBER_TABLE
466 , p8_a28 in out nocopy JTF_NUMBER_TABLE
467 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_100
468 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_100
469 , p8_a31 in out nocopy JTF_NUMBER_TABLE
470 , p9_a0 in out nocopy JTF_NUMBER_TABLE
471 , p9_a1 in out nocopy JTF_NUMBER_TABLE
472 , p9_a2 in out nocopy JTF_NUMBER_TABLE
473 , p9_a3 in out nocopy JTF_NUMBER_TABLE
474 , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
475 , p9_a5 in out nocopy JTF_NUMBER_TABLE
476 , p9_a6 in out nocopy JTF_NUMBER_TABLE
477 , p9_a7 in out nocopy JTF_DATE_TABLE
478 , p9_a8 in out nocopy JTF_DATE_TABLE
479 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
480 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
481 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
482 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
483 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
484 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
485 , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
486 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
487 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
488 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
489 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
490 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
491 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
492 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
493 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
494 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
495 , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
496 , p9_a26 in out nocopy JTF_NUMBER_TABLE
497 , p9_a27 in out nocopy JTF_NUMBER_TABLE
498 , p10_a0 in out nocopy JTF_NUMBER_TABLE
499 , p10_a1 in out nocopy JTF_NUMBER_TABLE
500 , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
501 , p10_a3 in out nocopy JTF_NUMBER_TABLE
502 , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_300
503 , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
504 , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
505 , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
506 , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
507 , p10_a9 in out nocopy JTF_DATE_TABLE
508 , p10_a10 in out nocopy JTF_DATE_TABLE
509 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
510 , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
511 , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
512 , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
513 , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
514 , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
515 , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
516 , p10_a18 in out nocopy JTF_VARCHAR2_TABLE_200
517 , p10_a19 in out nocopy JTF_VARCHAR2_TABLE_200
518 , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_200
519 , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
520 , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
521 , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
522 , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
523 , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
524 , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_200
525 , p10_a27 in out nocopy JTF_VARCHAR2_TABLE_200
526 , p10_a28 in out nocopy JTF_NUMBER_TABLE
527 , p10_a29 in out nocopy JTF_NUMBER_TABLE
528 , p11_a0 out nocopy JTF_NUMBER_TABLE
529 , p11_a1 out nocopy JTF_NUMBER_TABLE
530 , p11_a2 out nocopy JTF_NUMBER_TABLE
531 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
532 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
533 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
534 , x_return_status out nocopy VARCHAR2
535 , x_msg_count out nocopy NUMBER
536 , x_msg_data out nocopy VARCHAR2
537 );
538 procedure delete_mass_edit_batch(p_api_version NUMBER
539 , p_commit VARCHAR2
540 , p_init_msg_list VARCHAR2
541 , p_validation_level NUMBER
542 , x_return_status out nocopy VARCHAR2
543 , x_msg_count out nocopy NUMBER
544 , x_msg_data out nocopy VARCHAR2
545 , p4_a0 NUMBER := 0-1962.0724
546 , p4_a1 VARCHAR2 := fnd_api.g_miss_char
547 , p4_a2 NUMBER := 0-1962.0724
548 , p4_a3 NUMBER := 0-1962.0724
549 , p4_a4 VARCHAR2 := fnd_api.g_miss_char
550 , p4_a5 VARCHAR2 := fnd_api.g_miss_char
551 , p4_a6 VARCHAR2 := fnd_api.g_miss_char
552 , p4_a7 DATE := fnd_api.g_miss_date
553 , p4_a8 DATE := fnd_api.g_miss_date
554 , p4_a9 DATE := fnd_api.g_miss_date
555 , p4_a10 NUMBER := 0-1962.0724
556 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
557 );
558 procedure delete_mass_edit_batches(p_api_version NUMBER
559 , p_commit VARCHAR2
560 , p_init_msg_list VARCHAR2
561 , p_validation_level NUMBER
562 , p4_a0 JTF_NUMBER_TABLE
563 , p4_a1 JTF_VARCHAR2_TABLE_100
564 , p4_a2 JTF_NUMBER_TABLE
565 , p4_a3 JTF_NUMBER_TABLE
566 , p4_a4 JTF_VARCHAR2_TABLE_100
567 , p4_a5 JTF_VARCHAR2_TABLE_100
568 , p4_a6 JTF_VARCHAR2_TABLE_2000
569 , p4_a7 JTF_DATE_TABLE
570 , p4_a8 JTF_DATE_TABLE
571 , p4_a9 JTF_DATE_TABLE
572 , p4_a10 JTF_NUMBER_TABLE
573 , p4_a11 JTF_VARCHAR2_TABLE_100
574 , x_return_status out nocopy VARCHAR2
575 , x_msg_count out nocopy NUMBER
576 , x_msg_data out nocopy VARCHAR2
577 );
578 procedure get_mass_edit_details(p_api_version NUMBER
579 , p_commit VARCHAR2
580 , p_init_msg_list VARCHAR2
581 , p_validation_level NUMBER
582 , p4_a0 in out nocopy NUMBER
583 , p4_a1 in out nocopy VARCHAR2
584 , p4_a2 in out nocopy NUMBER
585 , p4_a3 in out nocopy NUMBER
586 , p4_a4 in out nocopy VARCHAR2
587 , p4_a5 in out nocopy VARCHAR2
588 , p4_a6 in out nocopy VARCHAR2
589 , p4_a7 in out nocopy DATE
590 , p4_a8 in out nocopy DATE
591 , p4_a9 in out nocopy DATE
592 , p4_a10 in out nocopy NUMBER
593 , p4_a11 in out nocopy VARCHAR2
594 , p5_a0 out nocopy JTF_NUMBER_TABLE
595 , p5_a1 out nocopy JTF_NUMBER_TABLE
596 , p5_a2 out nocopy JTF_NUMBER_TABLE
597 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
598 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
599 , p5_a5 out nocopy JTF_NUMBER_TABLE
600 , p5_a6 out nocopy JTF_NUMBER_TABLE
601 , p5_a7 out nocopy JTF_NUMBER_TABLE
602 , p5_a8 out nocopy JTF_NUMBER_TABLE
603 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
604 , p5_a10 out nocopy JTF_NUMBER_TABLE
605 , p5_a11 out nocopy JTF_NUMBER_TABLE
606 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
607 , p5_a13 out nocopy JTF_NUMBER_TABLE
608 , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
609 , p5_a15 out nocopy JTF_NUMBER_TABLE
610 , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
611 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
612 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
613 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
614 , p5_a20 out nocopy JTF_NUMBER_TABLE
615 , p5_a21 out nocopy JTF_DATE_TABLE
616 , p5_a22 out nocopy JTF_DATE_TABLE
617 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
618 , p5_a24 out nocopy JTF_NUMBER_TABLE
619 , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
620 , p5_a26 out nocopy JTF_VARCHAR2_TABLE_300
621 , p5_a27 out nocopy JTF_DATE_TABLE
622 , p5_a28 out nocopy JTF_DATE_TABLE
623 , p5_a29 out nocopy JTF_DATE_TABLE
624 , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
625 , p5_a31 out nocopy JTF_NUMBER_TABLE
626 , p5_a32 out nocopy JTF_NUMBER_TABLE
627 , p5_a33 out nocopy JTF_DATE_TABLE
628 , p5_a34 out nocopy JTF_NUMBER_TABLE
629 , p5_a35 out nocopy JTF_NUMBER_TABLE
630 , p5_a36 out nocopy JTF_NUMBER_TABLE
631 , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
632 , p5_a38 out nocopy JTF_VARCHAR2_TABLE_300
633 , p5_a39 out nocopy JTF_VARCHAR2_TABLE_300
634 , p5_a40 out nocopy JTF_NUMBER_TABLE
635 , p5_a41 out nocopy JTF_NUMBER_TABLE
636 , p5_a42 out nocopy JTF_NUMBER_TABLE
637 , p5_a43 out nocopy JTF_NUMBER_TABLE
638 , p5_a44 out nocopy JTF_NUMBER_TABLE
639 , p5_a45 out nocopy JTF_DATE_TABLE
640 , p5_a46 out nocopy JTF_VARCHAR2_TABLE_300
641 , p5_a47 out nocopy JTF_VARCHAR2_TABLE_100
642 , p5_a48 out nocopy JTF_VARCHAR2_TABLE_100
643 , p5_a49 out nocopy JTF_NUMBER_TABLE
644 , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
645 , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
646 , p5_a52 out nocopy JTF_VARCHAR2_TABLE_200
647 , p5_a53 out nocopy JTF_VARCHAR2_TABLE_200
648 , p5_a54 out nocopy JTF_VARCHAR2_TABLE_200
649 , p5_a55 out nocopy JTF_VARCHAR2_TABLE_200
650 , p5_a56 out nocopy JTF_VARCHAR2_TABLE_200
651 , p5_a57 out nocopy JTF_VARCHAR2_TABLE_200
652 , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
653 , p5_a59 out nocopy JTF_VARCHAR2_TABLE_200
654 , p5_a60 out nocopy JTF_VARCHAR2_TABLE_200
655 , p5_a61 out nocopy JTF_VARCHAR2_TABLE_200
656 , p5_a62 out nocopy JTF_VARCHAR2_TABLE_200
657 , p5_a63 out nocopy JTF_VARCHAR2_TABLE_200
658 , p5_a64 out nocopy JTF_VARCHAR2_TABLE_200
659 , p5_a65 out nocopy JTF_VARCHAR2_TABLE_200
660 , p5_a66 out nocopy JTF_VARCHAR2_TABLE_200
661 , p5_a67 out nocopy JTF_NUMBER_TABLE
662 , p5_a68 out nocopy JTF_NUMBER_TABLE
663 , p5_a69 out nocopy JTF_NUMBER_TABLE
664 , p5_a70 out nocopy JTF_NUMBER_TABLE
665 , p5_a71 out nocopy JTF_NUMBER_TABLE
666 , p6_a0 out nocopy JTF_NUMBER_TABLE
667 , p6_a1 out nocopy JTF_NUMBER_TABLE
668 , p6_a2 out nocopy JTF_NUMBER_TABLE
669 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
670 , p6_a4 out nocopy JTF_NUMBER_TABLE
671 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
672 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
673 , p6_a7 out nocopy JTF_NUMBER_TABLE
674 , p6_a8 out nocopy JTF_DATE_TABLE
675 , p6_a9 out nocopy JTF_DATE_TABLE
676 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
677 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
678 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
679 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
680 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
681 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
682 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
683 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
684 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
685 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
686 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
687 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
688 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
689 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_200
690 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
691 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_200
692 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_200
693 , p6_a27 out nocopy JTF_NUMBER_TABLE
694 , p6_a28 out nocopy JTF_NUMBER_TABLE
695 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
696 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
697 , p6_a31 out nocopy JTF_NUMBER_TABLE
698 , p7_a0 out nocopy JTF_NUMBER_TABLE
699 , p7_a1 out nocopy JTF_NUMBER_TABLE
700 , p7_a2 out nocopy JTF_NUMBER_TABLE
701 , p7_a3 out nocopy JTF_NUMBER_TABLE
702 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
703 , p7_a5 out nocopy JTF_NUMBER_TABLE
704 , p7_a6 out nocopy JTF_NUMBER_TABLE
705 , p7_a7 out nocopy JTF_DATE_TABLE
706 , p7_a8 out nocopy JTF_DATE_TABLE
707 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
708 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
709 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_200
710 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_200
711 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_200
712 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_200
713 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_200
714 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_200
715 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
716 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
717 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
718 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
719 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_200
720 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
721 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_200
722 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
723 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
724 , p7_a26 out nocopy JTF_NUMBER_TABLE
725 , p7_a27 out nocopy JTF_NUMBER_TABLE
726 , p8_a0 out nocopy JTF_NUMBER_TABLE
727 , p8_a1 out nocopy JTF_NUMBER_TABLE
728 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
729 , p8_a3 out nocopy JTF_NUMBER_TABLE
730 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
731 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
732 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
733 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
734 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
735 , p8_a9 out nocopy JTF_DATE_TABLE
736 , p8_a10 out nocopy JTF_DATE_TABLE
737 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
738 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
739 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
740 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
741 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_200
742 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
743 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
744 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
745 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200
746 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_200
747 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
748 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
749 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
750 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
751 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
752 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
753 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
754 , p8_a28 out nocopy JTF_NUMBER_TABLE
755 , p8_a29 out nocopy JTF_NUMBER_TABLE
756 , x_return_status out nocopy VARCHAR2
757 , x_msg_count out nocopy NUMBER
758 , x_msg_data out nocopy VARCHAR2
759 );
760 procedure process_system_mass_update(p_api_version NUMBER
761 , p_commit VARCHAR2
762 , p_entry_id NUMBER
763 , p3_a0 in out nocopy JTF_NUMBER_TABLE
764 , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
765 , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
766 , p3_a3 in out nocopy JTF_NUMBER_TABLE
767 , p3_a4 in out nocopy JTF_NUMBER_TABLE
768 , p3_a5 in out nocopy JTF_VARCHAR2_TABLE_100
769 , p3_a6 in out nocopy JTF_NUMBER_TABLE
770 , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_100
771 , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
772 , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
773 , p3_a10 in out nocopy JTF_NUMBER_TABLE
774 , p3_a11 in out nocopy JTF_VARCHAR2_TABLE_100
775 , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
776 , p3_a13 in out nocopy JTF_NUMBER_TABLE
777 , p3_a14 in out nocopy JTF_NUMBER_TABLE
778 , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
779 , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
780 , p3_a17 in out nocopy JTF_VARCHAR2_TABLE_100
781 , p3_a18 in out nocopy JTF_NUMBER_TABLE
782 , p3_a19 in out nocopy JTF_VARCHAR2_TABLE_100
783 , p3_a20 in out nocopy JTF_DATE_TABLE
784 , p3_a21 in out nocopy JTF_DATE_TABLE
785 , p3_a22 in out nocopy JTF_VARCHAR2_TABLE_100
786 , p3_a23 in out nocopy JTF_NUMBER_TABLE
787 , p3_a24 in out nocopy JTF_NUMBER_TABLE
788 , p3_a25 in out nocopy JTF_VARCHAR2_TABLE_100
789 , p3_a26 in out nocopy JTF_NUMBER_TABLE
790 , p3_a27 in out nocopy JTF_NUMBER_TABLE
791 , p3_a28 in out nocopy JTF_NUMBER_TABLE
792 , p3_a29 in out nocopy JTF_NUMBER_TABLE
793 , p3_a30 in out nocopy JTF_NUMBER_TABLE
794 , p3_a31 in out nocopy JTF_NUMBER_TABLE
795 , p3_a32 in out nocopy JTF_NUMBER_TABLE
796 , p3_a33 in out nocopy JTF_NUMBER_TABLE
797 , p3_a34 in out nocopy JTF_NUMBER_TABLE
798 , p3_a35 in out nocopy JTF_VARCHAR2_TABLE_100
799 , p3_a36 in out nocopy JTF_NUMBER_TABLE
800 , p3_a37 in out nocopy JTF_NUMBER_TABLE
801 , p3_a38 in out nocopy JTF_NUMBER_TABLE
802 , p3_a39 in out nocopy JTF_NUMBER_TABLE
803 , p3_a40 in out nocopy JTF_DATE_TABLE
804 , p3_a41 in out nocopy JTF_VARCHAR2_TABLE_100
805 , p3_a42 in out nocopy JTF_DATE_TABLE
806 , p3_a43 in out nocopy JTF_DATE_TABLE
807 , p3_a44 in out nocopy JTF_VARCHAR2_TABLE_100
808 , p3_a45 in out nocopy JTF_VARCHAR2_TABLE_100
809 , p3_a46 in out nocopy JTF_VARCHAR2_TABLE_300
810 , p3_a47 in out nocopy JTF_VARCHAR2_TABLE_300
811 , p3_a48 in out nocopy JTF_VARCHAR2_TABLE_100
812 , p3_a49 in out nocopy JTF_VARCHAR2_TABLE_300
813 , p3_a50 in out nocopy JTF_VARCHAR2_TABLE_300
814 , p3_a51 in out nocopy JTF_VARCHAR2_TABLE_300
815 , p3_a52 in out nocopy JTF_VARCHAR2_TABLE_300
816 , p3_a53 in out nocopy JTF_VARCHAR2_TABLE_300
817 , p3_a54 in out nocopy JTF_VARCHAR2_TABLE_300
818 , p3_a55 in out nocopy JTF_VARCHAR2_TABLE_300
819 , p3_a56 in out nocopy JTF_VARCHAR2_TABLE_300
820 , p3_a57 in out nocopy JTF_VARCHAR2_TABLE_300
821 , p3_a58 in out nocopy JTF_VARCHAR2_TABLE_300
822 , p3_a59 in out nocopy JTF_VARCHAR2_TABLE_300
823 , p3_a60 in out nocopy JTF_VARCHAR2_TABLE_300
824 , p3_a61 in out nocopy JTF_VARCHAR2_TABLE_300
825 , p3_a62 in out nocopy JTF_VARCHAR2_TABLE_300
826 , p3_a63 in out nocopy JTF_VARCHAR2_TABLE_300
827 , p3_a64 in out nocopy JTF_NUMBER_TABLE
828 , p3_a65 in out nocopy JTF_NUMBER_TABLE
829 , p3_a66 in out nocopy JTF_VARCHAR2_TABLE_100
830 , p3_a67 in out nocopy JTF_NUMBER_TABLE
831 , p3_a68 in out nocopy JTF_VARCHAR2_TABLE_100
832 , p3_a69 in out nocopy JTF_VARCHAR2_TABLE_100
833 , p3_a70 in out nocopy JTF_VARCHAR2_TABLE_100
834 , p3_a71 in out nocopy JTF_VARCHAR2_TABLE_100
835 , p3_a72 in out nocopy JTF_NUMBER_TABLE
836 , p3_a73 in out nocopy JTF_VARCHAR2_TABLE_100
837 , p3_a74 in out nocopy JTF_NUMBER_TABLE
838 , p3_a75 in out nocopy JTF_NUMBER_TABLE
839 , p3_a76 in out nocopy JTF_NUMBER_TABLE
840 , p3_a77 in out nocopy JTF_VARCHAR2_TABLE_100
841 , p3_a78 in out nocopy JTF_VARCHAR2_TABLE_300
842 , p3_a79 in out nocopy JTF_VARCHAR2_TABLE_100
843 , p3_a80 in out nocopy JTF_NUMBER_TABLE
844 , p3_a81 in out nocopy JTF_NUMBER_TABLE
845 , p3_a82 in out nocopy JTF_NUMBER_TABLE
846 , p3_a83 in out nocopy JTF_DATE_TABLE
847 , p3_a84 in out nocopy JTF_VARCHAR2_TABLE_100
848 , p3_a85 in out nocopy JTF_VARCHAR2_TABLE_100
849 , p3_a86 in out nocopy JTF_VARCHAR2_TABLE_100
850 , p3_a87 in out nocopy JTF_NUMBER_TABLE
851 , p3_a88 in out nocopy JTF_VARCHAR2_TABLE_100
852 , p3_a89 in out nocopy JTF_NUMBER_TABLE
853 , p3_a90 in out nocopy JTF_NUMBER_TABLE
854 , p3_a91 in out nocopy JTF_VARCHAR2_TABLE_100
855 , p3_a92 in out nocopy JTF_NUMBER_TABLE
856 , p3_a93 in out nocopy JTF_VARCHAR2_TABLE_100
857 , p3_a94 in out nocopy JTF_NUMBER_TABLE
858 , p3_a95 in out nocopy JTF_DATE_TABLE
859 , p3_a96 in out nocopy JTF_VARCHAR2_TABLE_300
860 , p3_a97 in out nocopy JTF_VARCHAR2_TABLE_300
861 , p3_a98 in out nocopy JTF_VARCHAR2_TABLE_300
862 , p3_a99 in out nocopy JTF_VARCHAR2_TABLE_300
863 , p3_a100 in out nocopy JTF_VARCHAR2_TABLE_300
864 , p3_a101 in out nocopy JTF_VARCHAR2_TABLE_300
865 , p3_a102 in out nocopy JTF_VARCHAR2_TABLE_300
866 , p3_a103 in out nocopy JTF_VARCHAR2_TABLE_300
867 , p3_a104 in out nocopy JTF_VARCHAR2_TABLE_300
868 , p3_a105 in out nocopy JTF_VARCHAR2_TABLE_300
869 , p3_a106 in out nocopy JTF_VARCHAR2_TABLE_300
870 , p3_a107 in out nocopy JTF_VARCHAR2_TABLE_300
871 , p3_a108 in out nocopy JTF_VARCHAR2_TABLE_300
872 , p3_a109 in out nocopy JTF_VARCHAR2_TABLE_300
873 , p3_a110 in out nocopy JTF_VARCHAR2_TABLE_300
874 , p3_a111 in out nocopy JTF_NUMBER_TABLE
875 , p3_a112 in out nocopy JTF_VARCHAR2_TABLE_100
876 , p3_a113 in out nocopy JTF_NUMBER_TABLE
877 , p3_a114 in out nocopy JTF_VARCHAR2_TABLE_100
878 , p3_a115 in out nocopy JTF_NUMBER_TABLE
879 , p3_a116 in out nocopy JTF_VARCHAR2_TABLE_100
880 , p3_a117 in out nocopy JTF_VARCHAR2_TABLE_100
881 , p3_a118 in out nocopy JTF_NUMBER_TABLE
882 , p3_a119 in out nocopy JTF_VARCHAR2_TABLE_100
883 , p3_a120 in out nocopy JTF_NUMBER_TABLE
884 , p3_a121 in out nocopy JTF_NUMBER_TABLE
885 , p3_a122 in out nocopy JTF_VARCHAR2_TABLE_100
886 , p4_a0 in out nocopy JTF_NUMBER_TABLE
887 , p4_a1 in out nocopy JTF_NUMBER_TABLE
888 , p4_a2 in out nocopy JTF_NUMBER_TABLE
889 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
890 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
891 , p4_a5 in out nocopy JTF_DATE_TABLE
892 , p4_a6 in out nocopy JTF_DATE_TABLE
893 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
894 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_200
895 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_200
896 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_200
897 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
898 , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
899 , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_200
900 , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
901 , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
902 , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
903 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
904 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
905 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
906 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
907 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
908 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
909 , p4_a23 in out nocopy JTF_NUMBER_TABLE
910 , p4_a24 in out nocopy JTF_NUMBER_TABLE
911 , p5_a0 in out nocopy JTF_NUMBER_TABLE
912 , p5_a1 in out nocopy JTF_NUMBER_TABLE
913 , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
914 , p5_a3 in out nocopy JTF_NUMBER_TABLE
915 , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
916 , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
917 , p5_a6 in out nocopy JTF_NUMBER_TABLE
918 , p5_a7 in out nocopy JTF_DATE_TABLE
919 , p5_a8 in out nocopy JTF_DATE_TABLE
920 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
921 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
922 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
923 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
924 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
925 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
926 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
927 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
928 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
929 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
930 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
931 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
932 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
933 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
934 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
935 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
936 , p5_a25 in out nocopy JTF_NUMBER_TABLE
937 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
938 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
939 , p5_a28 in out nocopy JTF_NUMBER_TABLE
940 , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
941 , p5_a30 in out nocopy JTF_NUMBER_TABLE
942 , p5_a31 in out nocopy JTF_NUMBER_TABLE
943 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
944 , p6_a0 in out nocopy JTF_NUMBER_TABLE
945 , p6_a1 in out nocopy JTF_NUMBER_TABLE
946 , p6_a2 in out nocopy JTF_NUMBER_TABLE
947 , p6_a3 in out nocopy JTF_NUMBER_TABLE
948 , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
949 , p6_a5 in out nocopy JTF_NUMBER_TABLE
950 , p6_a6 in out nocopy JTF_NUMBER_TABLE
951 , p6_a7 in out nocopy JTF_DATE_TABLE
952 , p6_a8 in out nocopy JTF_DATE_TABLE
953 , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
954 , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
955 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956 , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
957 , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
958 , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
959 , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
960 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
961 , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
962 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
963 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
964 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
965 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
966 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
967 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
968 , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
969 , p6_a25 in out nocopy JTF_NUMBER_TABLE
970 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
971 , p6_a27 in out nocopy JTF_NUMBER_TABLE
972 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_100
973 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
974 , p6_a30 in out nocopy JTF_NUMBER_TABLE
975 , p6_a31 in out nocopy JTF_NUMBER_TABLE
976 , p6_a32 in out nocopy JTF_NUMBER_TABLE
977 , p6_a33 in out nocopy JTF_DATE_TABLE
978 , p6_a34 in out nocopy JTF_NUMBER_TABLE
979 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
980 , p7_a0 in out nocopy NUMBER
981 , p7_a1 in out nocopy DATE
982 , p7_a2 in out nocopy DATE
983 , p7_a3 in out nocopy NUMBER
984 , p7_a4 in out nocopy NUMBER
985 , p7_a5 in out nocopy NUMBER
986 , p7_a6 in out nocopy VARCHAR2
987 , p7_a7 in out nocopy NUMBER
988 , p7_a8 in out nocopy VARCHAR2
989 , p7_a9 in out nocopy NUMBER
990 , p7_a10 in out nocopy VARCHAR2
991 , p7_a11 in out nocopy NUMBER
992 , p7_a12 in out nocopy NUMBER
993 , p7_a13 in out nocopy NUMBER
994 , p7_a14 in out nocopy NUMBER
995 , p7_a15 in out nocopy VARCHAR2
996 , p7_a16 in out nocopy NUMBER
997 , p7_a17 in out nocopy VARCHAR2
998 , p7_a18 in out nocopy VARCHAR2
999 , p7_a19 in out nocopy NUMBER
1000 , p7_a20 in out nocopy VARCHAR2
1001 , p7_a21 in out nocopy VARCHAR2
1002 , p7_a22 in out nocopy VARCHAR2
1003 , p7_a23 in out nocopy VARCHAR2
1004 , p7_a24 in out nocopy VARCHAR2
1005 , p7_a25 in out nocopy VARCHAR2
1006 , p7_a26 in out nocopy VARCHAR2
1007 , p7_a27 in out nocopy VARCHAR2
1008 , p7_a28 in out nocopy VARCHAR2
1009 , p7_a29 in out nocopy VARCHAR2
1010 , p7_a30 in out nocopy VARCHAR2
1011 , p7_a31 in out nocopy VARCHAR2
1012 , p7_a32 in out nocopy VARCHAR2
1013 , p7_a33 in out nocopy VARCHAR2
1014 , p7_a34 in out nocopy VARCHAR2
1015 , p7_a35 in out nocopy VARCHAR2
1016 , p7_a36 in out nocopy NUMBER
1017 , p7_a37 in out nocopy VARCHAR2
1018 , p7_a38 in out nocopy DATE
1019 , p7_a39 in out nocopy NUMBER
1020 , x_return_status out nocopy VARCHAR2
1021 , x_msg_count out nocopy NUMBER
1022 , x_msg_data out nocopy VARCHAR2
1023 );
1024 procedure identify_system_for_update(p_txn_line_id NUMBER
1025 , p1_a0 out nocopy JTF_NUMBER_TABLE
1026 , x_return_status out nocopy VARCHAR2
1027 );
1028 procedure validate_system_batch(p_entry_id NUMBER
1029 , p_txn_line_id NUMBER
1030 , p2_a0 JTF_NUMBER_TABLE
1031 , x_return_status out nocopy VARCHAR2
1032 );
1033 end csi_mass_edit_pub_w;
[Home] [Help]