1 package fun_trx_pvt_w AUTHID CURRENT_USER as
2 /* $Header: fun_trx_pvt_w_s.pls 120.10 2011/12/16 02:26:05 srampure ship $ */
3 TYPE numarray IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(100);
4 procedure rosetta_table_copy_in_p5(t out nocopy fun_trx_pvt.batch_tbl_type, a0 JTF_NUMBER_TABLE
5 , a1 JTF_VARCHAR2_TABLE_100
6 , a2 JTF_NUMBER_TABLE
7 , a3 JTF_NUMBER_TABLE
8 , a4 JTF_NUMBER_TABLE
9 , a5 JTF_NUMBER_TABLE
10 , a6 JTF_VARCHAR2_TABLE_100
11 , a7 JTF_VARCHAR2_TABLE_100
12 , a8 JTF_VARCHAR2_TABLE_100
13 , a9 JTF_VARCHAR2_TABLE_300
14 , a10 JTF_NUMBER_TABLE
15 , a11 JTF_VARCHAR2_TABLE_100
16 , a12 JTF_DATE_TABLE
17 , a13 JTF_DATE_TABLE
18 , a14 JTF_VARCHAR2_TABLE_100
19 , a15 JTF_NUMBER_TABLE
20 , a16 JTF_VARCHAR2_TABLE_100
21 );
22 procedure rosetta_table_copy_out_p5(t fun_trx_pvt.batch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23 , a1 out nocopy JTF_VARCHAR2_TABLE_100
24 , a2 out nocopy JTF_NUMBER_TABLE
25 , a3 out nocopy JTF_NUMBER_TABLE
26 , a4 out nocopy JTF_NUMBER_TABLE
27 , a5 out nocopy JTF_NUMBER_TABLE
28 , a6 out nocopy JTF_VARCHAR2_TABLE_100
29 , a7 out nocopy JTF_VARCHAR2_TABLE_100
30 , a8 out nocopy JTF_VARCHAR2_TABLE_100
31 , a9 out nocopy JTF_VARCHAR2_TABLE_300
32 , a10 out nocopy JTF_NUMBER_TABLE
33 , a11 out nocopy JTF_VARCHAR2_TABLE_100
34 , a12 out nocopy JTF_DATE_TABLE
35 , a13 out nocopy JTF_DATE_TABLE
36 , a14 out nocopy JTF_VARCHAR2_TABLE_100
37 , a15 out nocopy JTF_NUMBER_TABLE
38 , a16 out nocopy JTF_VARCHAR2_TABLE_100
39 );
40
41 procedure rosetta_table_copy_in_p6(t out nocopy fun_trx_pvt.trx_tbl_type, a0 JTF_NUMBER_TABLE
42 , a1 JTF_NUMBER_TABLE
43 , a2 JTF_NUMBER_TABLE
44 , a3 JTF_NUMBER_TABLE
45 , a4 JTF_NUMBER_TABLE
46 , a5 JTF_NUMBER_TABLE
47 , a6 JTF_VARCHAR2_TABLE_100
48 , a7 JTF_NUMBER_TABLE
49 , a8 JTF_NUMBER_TABLE
50 , a9 JTF_NUMBER_TABLE
51 , a10 JTF_NUMBER_TABLE
52 , a11 JTF_VARCHAR2_TABLE_100
53 , a12 JTF_VARCHAR2_TABLE_100
54 , a13 JTF_NUMBER_TABLE
55 , a14 JTF_DATE_TABLE
56 , a15 JTF_NUMBER_TABLE
57 , a16 JTF_NUMBER_TABLE
58 , a17 JTF_NUMBER_TABLE
59 , a18 JTF_VARCHAR2_TABLE_100
60 , a19 JTF_VARCHAR2_TABLE_100
61 , a20 JTF_VARCHAR2_TABLE_100
62 , a21 JTF_VARCHAR2_TABLE_100
63 );
64 procedure rosetta_table_copy_out_p6(t fun_trx_pvt.trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_NUMBER_TABLE
66 , a2 out nocopy JTF_NUMBER_TABLE
67 , a3 out nocopy JTF_NUMBER_TABLE
68 , a4 out nocopy JTF_NUMBER_TABLE
69 , a5 out nocopy JTF_NUMBER_TABLE
70 , a6 out nocopy JTF_VARCHAR2_TABLE_100
71 , a7 out nocopy JTF_NUMBER_TABLE
72 , a8 out nocopy JTF_NUMBER_TABLE
73 , a9 out nocopy JTF_NUMBER_TABLE
74 , a10 out nocopy JTF_NUMBER_TABLE
75 , a11 out nocopy JTF_VARCHAR2_TABLE_100
76 , a12 out nocopy JTF_VARCHAR2_TABLE_100
77 , a13 out nocopy JTF_NUMBER_TABLE
78 , a14 out nocopy JTF_DATE_TABLE
79 , a15 out nocopy JTF_NUMBER_TABLE
80 , a16 out nocopy JTF_NUMBER_TABLE
81 , a17 out nocopy JTF_NUMBER_TABLE
82 , a18 out nocopy JTF_VARCHAR2_TABLE_100
83 , a19 out nocopy JTF_VARCHAR2_TABLE_100
84 , a20 out nocopy JTF_VARCHAR2_TABLE_100
85 , a21 out nocopy JTF_VARCHAR2_TABLE_100
86 );
87
88 procedure rosetta_table_copy_in_p7(t out nocopy fun_trx_pvt.line_tbl_type, a0 JTF_NUMBER_TABLE
89 , a1 JTF_NUMBER_TABLE
90 , a2 JTF_NUMBER_TABLE
91 , a3 JTF_VARCHAR2_TABLE_100
92 , a4 JTF_NUMBER_TABLE
93 , a5 JTF_NUMBER_TABLE
94 , a6 JTF_NUMBER_TABLE
95 , a7 JTF_NUMBER_TABLE
96 );
97 procedure rosetta_table_copy_out_p7(t fun_trx_pvt.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98 , a1 out nocopy JTF_NUMBER_TABLE
99 , a2 out nocopy JTF_NUMBER_TABLE
100 , a3 out nocopy JTF_VARCHAR2_TABLE_100
101 , a4 out nocopy JTF_NUMBER_TABLE
102 , a5 out nocopy JTF_NUMBER_TABLE
103 , a6 out nocopy JTF_NUMBER_TABLE
104 , a7 out nocopy JTF_NUMBER_TABLE
105 );
106
107 procedure rosetta_table_copy_in_p8(t out nocopy fun_trx_pvt.init_dist_tbl_type, a0 JTF_NUMBER_TABLE
108 , a1 JTF_NUMBER_TABLE
109 , a2 JTF_NUMBER_TABLE
110 , a3 JTF_NUMBER_TABLE
111 , a4 JTF_NUMBER_TABLE
112 , a5 JTF_NUMBER_TABLE
113 , a6 JTF_VARCHAR2_TABLE_300
114 );
115 procedure rosetta_table_copy_out_p8(t fun_trx_pvt.init_dist_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116 , a1 out nocopy JTF_NUMBER_TABLE
117 , a2 out nocopy JTF_NUMBER_TABLE
118 , a3 out nocopy JTF_NUMBER_TABLE
119 , a4 out nocopy JTF_NUMBER_TABLE
120 , a5 out nocopy JTF_NUMBER_TABLE
121 , a6 out nocopy JTF_VARCHAR2_TABLE_300
122 );
123
124 procedure rosetta_table_copy_in_p9(t out nocopy fun_trx_pvt.dist_line_tbl_type, a0 JTF_NUMBER_TABLE
125 , a1 JTF_NUMBER_TABLE
126 , a2 JTF_NUMBER_TABLE
127 , a3 JTF_NUMBER_TABLE
128 , a4 JTF_NUMBER_TABLE
129 , a5 JTF_VARCHAR2_TABLE_100
130 , a6 JTF_VARCHAR2_TABLE_100
131 , a7 JTF_NUMBER_TABLE
132 , a8 JTF_NUMBER_TABLE
133 , a9 JTF_NUMBER_TABLE
134 , a10 JTF_NUMBER_TABLE
135 , a11 JTF_VARCHAR2_TABLE_100
136 );
137 procedure rosetta_table_copy_out_p9(t fun_trx_pvt.dist_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138 , a1 out nocopy JTF_NUMBER_TABLE
139 , a2 out nocopy JTF_NUMBER_TABLE
140 , a3 out nocopy JTF_NUMBER_TABLE
141 , a4 out nocopy JTF_NUMBER_TABLE
142 , a5 out nocopy JTF_VARCHAR2_TABLE_100
143 , a6 out nocopy JTF_VARCHAR2_TABLE_100
144 , a7 out nocopy JTF_NUMBER_TABLE
145 , a8 out nocopy JTF_NUMBER_TABLE
146 , a9 out nocopy JTF_NUMBER_TABLE
147 , a10 out nocopy JTF_NUMBER_TABLE
148 , a11 out nocopy JTF_VARCHAR2_TABLE_100
149 );
150
151 procedure rosetta_table_copy_in_p10(t out nocopy fun_trx_pvt.number_type, a0 JTF_NUMBER_TABLE);
152 procedure rosetta_table_copy_out_p10(t fun_trx_pvt.number_type, a0 out nocopy JTF_NUMBER_TABLE);
153
154 procedure init_batch_validate(p_api_version NUMBER
155 , p_init_msg_list VARCHAR2
156 , p_validation_level NUMBER
157 , x_return_status out nocopy VARCHAR2
158 , x_msg_count out nocopy NUMBER
159 , x_msg_data out nocopy VARCHAR2
160 , p_insert VARCHAR2
161 , p7_a0 in out nocopy NUMBER
162 , p7_a1 in out nocopy VARCHAR2
163 , p7_a2 in out nocopy NUMBER
164 , p7_a3 in out nocopy NUMBER
165 , p7_a4 in out nocopy NUMBER
166 , p7_a5 in out nocopy NUMBER
167 , p7_a6 in out nocopy VARCHAR2
168 , p7_a7 in out nocopy VARCHAR2
169 , p7_a8 in out nocopy VARCHAR2
170 , p7_a9 in out nocopy VARCHAR2
171 , p7_a10 in out nocopy NUMBER
172 , p7_a11 in out nocopy VARCHAR2
173 , p7_a12 in out nocopy DATE
174 , p7_a13 in out nocopy DATE
175 , p7_a14 in out nocopy VARCHAR2
176 , p7_a15 in out nocopy NUMBER
177 , p7_a16 in out nocopy VARCHAR2
178 , p8_a0 in out nocopy JTF_NUMBER_TABLE
179 , p8_a1 in out nocopy JTF_NUMBER_TABLE
180 , p8_a2 in out nocopy JTF_NUMBER_TABLE
181 , p8_a3 in out nocopy JTF_NUMBER_TABLE
182 , p8_a4 in out nocopy JTF_NUMBER_TABLE
183 , p8_a5 in out nocopy JTF_NUMBER_TABLE
184 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
185 , p8_a7 in out nocopy JTF_NUMBER_TABLE
186 , p8_a8 in out nocopy JTF_NUMBER_TABLE
187 , p8_a9 in out nocopy JTF_NUMBER_TABLE
188 , p8_a10 in out nocopy JTF_NUMBER_TABLE
189 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
190 , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_100
191 , p8_a13 in out nocopy JTF_NUMBER_TABLE
192 , p8_a14 in out nocopy JTF_DATE_TABLE
193 , p8_a15 in out nocopy JTF_NUMBER_TABLE
194 , p8_a16 in out nocopy JTF_NUMBER_TABLE
195 , p8_a17 in out nocopy JTF_NUMBER_TABLE
196 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_100
197 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_100
198 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_100
199 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_100
200 , p9_a0 in out nocopy JTF_NUMBER_TABLE
201 , p9_a1 in out nocopy JTF_NUMBER_TABLE
202 , p9_a2 in out nocopy JTF_NUMBER_TABLE
203 , p9_a3 in out nocopy JTF_NUMBER_TABLE
204 , p9_a4 in out nocopy JTF_NUMBER_TABLE
205 , p9_a5 in out nocopy JTF_NUMBER_TABLE
206 , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
207 , p10_a0 in out nocopy JTF_NUMBER_TABLE
208 , p10_a1 in out nocopy JTF_NUMBER_TABLE
209 , p10_a2 in out nocopy JTF_NUMBER_TABLE
210 , p10_a3 in out nocopy JTF_NUMBER_TABLE
211 , p10_a4 in out nocopy JTF_NUMBER_TABLE
212 , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
213 , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
214 , p10_a7 in out nocopy JTF_NUMBER_TABLE
215 , p10_a8 in out nocopy JTF_NUMBER_TABLE
216 , p10_a9 in out nocopy JTF_NUMBER_TABLE
217 , p10_a10 in out nocopy JTF_NUMBER_TABLE
218 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
219 );
220 procedure init_trx_validate(p_api_version NUMBER
221 , p_init_msg_list VARCHAR2
222 , p_validation_level NUMBER
223 , x_return_status out nocopy VARCHAR2
224 , x_msg_count out nocopy NUMBER
225 , x_msg_data out nocopy VARCHAR2
226 , p6_a0 in out nocopy NUMBER
227 , p6_a1 in out nocopy NUMBER
228 , p6_a2 in out nocopy NUMBER
229 , p6_a3 in out nocopy NUMBER
230 , p6_a4 in out nocopy NUMBER
231 , p6_a5 in out nocopy NUMBER
232 , p6_a6 in out nocopy VARCHAR2
233 , p6_a7 in out nocopy NUMBER
234 , p6_a8 in out nocopy NUMBER
235 , p6_a9 in out nocopy NUMBER
236 , p6_a10 in out nocopy NUMBER
237 , p6_a11 in out nocopy VARCHAR2
238 , p6_a12 in out nocopy VARCHAR2
239 , p6_a13 in out nocopy NUMBER
240 , p6_a14 in out nocopy DATE
241 , p6_a15 in out nocopy NUMBER
242 , p6_a16 in out nocopy NUMBER
243 , p6_a17 in out nocopy NUMBER
244 , p6_a18 in out nocopy VARCHAR2
245 , p6_a19 in out nocopy VARCHAR2
246 , p6_a20 in out nocopy VARCHAR2
247 , p6_a21 in out nocopy VARCHAR2
248 , p7_a0 in out nocopy JTF_NUMBER_TABLE
249 , p7_a1 in out nocopy JTF_NUMBER_TABLE
250 , p7_a2 in out nocopy JTF_NUMBER_TABLE
251 , p7_a3 in out nocopy JTF_NUMBER_TABLE
252 , p7_a4 in out nocopy JTF_NUMBER_TABLE
253 , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
254 , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
255 , p7_a7 in out nocopy JTF_NUMBER_TABLE
256 , p7_a8 in out nocopy JTF_NUMBER_TABLE
257 , p7_a9 in out nocopy JTF_NUMBER_TABLE
258 , p7_a10 in out nocopy JTF_NUMBER_TABLE
259 , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_100
260 , p_currency_code VARCHAR2
261 , p_gl_date DATE
262 , p_trx_date DATE
263 , p_exchange_rate_type VARCHAR2
264 );
265 procedure init_dist_validate(p_api_version NUMBER
266 , p_init_msg_list VARCHAR2
267 , p_validation_level NUMBER
268 , p_le_id NUMBER
269 , p_ledger_id NUMBER
270 , x_return_status out nocopy VARCHAR2
271 , x_msg_count out nocopy NUMBER
272 , x_msg_data out nocopy VARCHAR2
273 , p8_a0 in out nocopy NUMBER
274 , p8_a1 in out nocopy NUMBER
275 , p8_a2 in out nocopy NUMBER
276 , p8_a3 in out nocopy NUMBER
277 , p8_a4 in out nocopy NUMBER
278 , p8_a5 in out nocopy NUMBER
279 , p8_a6 in out nocopy VARCHAR2
280 );
281 procedure init_ic_dist_validate(p_api_version NUMBER
282 , p_init_msg_list VARCHAR2
283 , p_validation_level NUMBER
284 , p_le_id NUMBER
285 , p_ledger_id NUMBER
286 , x_return_status out nocopy VARCHAR2
287 , x_msg_count out nocopy NUMBER
288 , x_msg_data out nocopy VARCHAR2
289 , p8_a0 in out nocopy NUMBER
290 , p8_a1 in out nocopy NUMBER
291 , p8_a2 in out nocopy NUMBER
292 , p8_a3 in out nocopy NUMBER
293 , p8_a4 in out nocopy NUMBER
294 , p8_a5 in out nocopy VARCHAR2
295 , p8_a6 in out nocopy VARCHAR2
296 , p8_a7 in out nocopy NUMBER
297 , p8_a8 in out nocopy NUMBER
298 , p8_a9 in out nocopy NUMBER
299 , p8_a10 in out nocopy NUMBER
300 , p8_a11 in out nocopy VARCHAR2
301 );
302 procedure init_generate_distributions(p_api_version NUMBER
303 , p_init_msg_list VARCHAR2
304 , x_return_status out nocopy VARCHAR2
305 , x_msg_count out nocopy NUMBER
306 , x_msg_data out nocopy VARCHAR2
307 , p5_a0 in out nocopy NUMBER
308 , p5_a1 in out nocopy VARCHAR2
309 , p5_a2 in out nocopy NUMBER
310 , p5_a3 in out nocopy NUMBER
311 , p5_a4 in out nocopy NUMBER
312 , p5_a5 in out nocopy NUMBER
313 , p5_a6 in out nocopy VARCHAR2
314 , p5_a7 in out nocopy VARCHAR2
315 , p5_a8 in out nocopy VARCHAR2
316 , p5_a9 in out nocopy VARCHAR2
317 , p5_a10 in out nocopy NUMBER
318 , p5_a11 in out nocopy VARCHAR2
319 , p5_a12 in out nocopy DATE
320 , p5_a13 in out nocopy DATE
321 , p5_a14 in out nocopy VARCHAR2
322 , p5_a15 in out nocopy NUMBER
323 , p5_a16 in out nocopy VARCHAR2
324 , p6_a0 in out nocopy JTF_NUMBER_TABLE
325 , p6_a1 in out nocopy JTF_NUMBER_TABLE
326 , p6_a2 in out nocopy JTF_NUMBER_TABLE
327 , p6_a3 in out nocopy JTF_NUMBER_TABLE
328 , p6_a4 in out nocopy JTF_NUMBER_TABLE
329 , p6_a5 in out nocopy JTF_NUMBER_TABLE
330 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
331 , p6_a7 in out nocopy JTF_NUMBER_TABLE
332 , p6_a8 in out nocopy JTF_NUMBER_TABLE
333 , p6_a9 in out nocopy JTF_NUMBER_TABLE
334 , p6_a10 in out nocopy JTF_NUMBER_TABLE
335 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
336 , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_100
337 , p6_a13 in out nocopy JTF_NUMBER_TABLE
338 , p6_a14 in out nocopy JTF_DATE_TABLE
339 , p6_a15 in out nocopy JTF_NUMBER_TABLE
340 , p6_a16 in out nocopy JTF_NUMBER_TABLE
341 , p6_a17 in out nocopy JTF_NUMBER_TABLE
342 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
343 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100
344 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_100
345 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_100
346 , p7_a0 in out nocopy JTF_NUMBER_TABLE
347 , p7_a1 in out nocopy JTF_NUMBER_TABLE
348 , p7_a2 in out nocopy JTF_NUMBER_TABLE
349 , p7_a3 in out nocopy JTF_NUMBER_TABLE
350 , p7_a4 in out nocopy JTF_NUMBER_TABLE
351 , p7_a5 in out nocopy JTF_NUMBER_TABLE
352 , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_300
353 , p8_a0 in out nocopy JTF_NUMBER_TABLE
354 , p8_a1 in out nocopy JTF_NUMBER_TABLE
355 , p8_a2 in out nocopy JTF_NUMBER_TABLE
356 , p8_a3 in out nocopy JTF_NUMBER_TABLE
357 , p8_a4 in out nocopy JTF_NUMBER_TABLE
358 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
359 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
360 , p8_a7 in out nocopy JTF_NUMBER_TABLE
361 , p8_a8 in out nocopy JTF_NUMBER_TABLE
362 , p8_a9 in out nocopy JTF_NUMBER_TABLE
363 , p8_a10 in out nocopy JTF_NUMBER_TABLE
364 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
365 );
366 procedure create_reverse_trx(p_api_version NUMBER
367 , p_init_msg_list VARCHAR2
368 , p_commit VARCHAR2
369 , p_validation_level NUMBER
370 , p_trx_tbl_id JTF_NUMBER_TABLE
371 , p_reversed_batch_number VARCHAR2
372 , p_reversal_method VARCHAR2
373 , p_reversed_batch_date DATE
374 , p_reversed_gl_date DATE
375 , p_reversed_description VARCHAR2
376 , x_return_status out nocopy VARCHAR2
377 , x_reversed_batch_id in out nocopy NUMBER
378 );
379 procedure recipient_validate(p_api_version NUMBER
380 , p_init_msg_list VARCHAR2
381 , p_validation_level NUMBER
382 , x_return_status out nocopy VARCHAR2
383 , x_msg_count out nocopy NUMBER
384 , x_msg_data out nocopy VARCHAR2
388 , p6_a3 in out nocopy NUMBER
385 , p6_a0 in out nocopy NUMBER
386 , p6_a1 in out nocopy VARCHAR2
387 , p6_a2 in out nocopy NUMBER
389 , p6_a4 in out nocopy NUMBER
390 , p6_a5 in out nocopy NUMBER
391 , p6_a6 in out nocopy VARCHAR2
392 , p6_a7 in out nocopy VARCHAR2
393 , p6_a8 in out nocopy VARCHAR2
394 , p6_a9 in out nocopy VARCHAR2
395 , p6_a10 in out nocopy NUMBER
396 , p6_a11 in out nocopy VARCHAR2
397 , p6_a12 in out nocopy DATE
398 , p6_a13 in out nocopy DATE
399 , p6_a14 in out nocopy VARCHAR2
400 , p6_a15 in out nocopy NUMBER
401 , p6_a16 in out nocopy VARCHAR2
402 , p7_a0 in out nocopy NUMBER
403 , p7_a1 in out nocopy NUMBER
404 , p7_a2 in out nocopy NUMBER
405 , p7_a3 in out nocopy NUMBER
406 , p7_a4 in out nocopy NUMBER
407 , p7_a5 in out nocopy NUMBER
408 , p7_a6 in out nocopy VARCHAR2
409 , p7_a7 in out nocopy NUMBER
410 , p7_a8 in out nocopy NUMBER
411 , p7_a9 in out nocopy NUMBER
412 , p7_a10 in out nocopy NUMBER
413 , p7_a11 in out nocopy VARCHAR2
414 , p7_a12 in out nocopy VARCHAR2
415 , p7_a13 in out nocopy NUMBER
416 , p7_a14 in out nocopy DATE
417 , p7_a15 in out nocopy NUMBER
418 , p7_a16 in out nocopy NUMBER
419 , p7_a17 in out nocopy NUMBER
420 , p7_a18 in out nocopy VARCHAR2
421 , p7_a19 in out nocopy VARCHAR2
422 , p7_a20 in out nocopy VARCHAR2
423 , p7_a21 in out nocopy VARCHAR2
424 , p8_a0 in out nocopy JTF_NUMBER_TABLE
425 , p8_a1 in out nocopy JTF_NUMBER_TABLE
426 , p8_a2 in out nocopy JTF_NUMBER_TABLE
427 , p8_a3 in out nocopy JTF_NUMBER_TABLE
428 , p8_a4 in out nocopy JTF_NUMBER_TABLE
429 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
430 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
431 , p8_a7 in out nocopy JTF_NUMBER_TABLE
432 , p8_a8 in out nocopy JTF_NUMBER_TABLE
433 , p8_a9 in out nocopy JTF_NUMBER_TABLE
434 , p8_a10 in out nocopy JTF_NUMBER_TABLE
435 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
436 );
437
438 procedure Modified(p_api_version NUMBER
439 , p_init_msg_list VARCHAR2
440 , p_validation_level NUMBER
441 , x_return_status out nocopy VARCHAR2
442 , x_msg_count out nocopy NUMBER
443 , x_msg_data out nocopy VARCHAR2
444 , p6_a0 in out nocopy NUMBER
445 , p6_a1 in out nocopy VARCHAR2
446 , p6_a2 in out nocopy NUMBER
447 , p6_a3 in out nocopy NUMBER
448 , p6_a4 in out nocopy NUMBER
449 , p6_a5 in out nocopy NUMBER
450 , p6_a6 in out nocopy VARCHAR2
451 , p6_a7 in out nocopy VARCHAR2
452 , p6_a8 in out nocopy VARCHAR2
453 , p6_a9 in out nocopy VARCHAR2
454 , p6_a10 in out nocopy NUMBER
455 , p6_a11 in out nocopy VARCHAR2
456 , p6_a12 in out nocopy DATE
457 , p6_a13 in out nocopy DATE
458 , p6_a14 in out nocopy VARCHAR2
459 , p6_a15 in out nocopy NUMBER
460 , p6_a16 in out nocopy VARCHAR2
461 , p7_a0 in out nocopy NUMBER
462 , p7_a1 in out nocopy NUMBER
463 , p7_a2 in out nocopy NUMBER
464 , p7_a3 in out nocopy NUMBER
465 , p7_a4 in out nocopy NUMBER
466 , p7_a5 in out nocopy NUMBER
467 , p7_a6 in out nocopy VARCHAR2
468 , p7_a7 in out nocopy NUMBER
469 , p7_a8 in out nocopy NUMBER
470 , p7_a9 in out nocopy NUMBER
471 , p7_a10 in out nocopy NUMBER
472 , p7_a11 in out nocopy VARCHAR2
473 , p7_a12 in out nocopy VARCHAR2
474 , p7_a13 in out nocopy NUMBER
475 , p7_a14 in out nocopy DATE
476 , p7_a15 in out nocopy NUMBER
477 , p7_a16 in out nocopy NUMBER
478 , p7_a17 in out nocopy NUMBER
479 , p7_a18 in out nocopy VARCHAR2
480 , p7_a19 in out nocopy VARCHAR2
481 , p7_a20 in out nocopy VARCHAR2
482 , p7_a21 in out nocopy VARCHAR2
483 , p8_a0 in out nocopy JTF_NUMBER_TABLE
484 , p8_a1 in out nocopy JTF_NUMBER_TABLE
485 , p8_a2 in out nocopy JTF_NUMBER_TABLE
486 , p8_a3 in out nocopy JTF_NUMBER_TABLE
487 , p8_a4 in out nocopy JTF_NUMBER_TABLE
488 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
489 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
493 , p8_a10 in out nocopy JTF_NUMBER_TABLE
490 , p8_a7 in out nocopy JTF_NUMBER_TABLE
491 , p8_a8 in out nocopy JTF_NUMBER_TABLE
492 , p8_a9 in out nocopy JTF_NUMBER_TABLE
494 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
495 );
496
497 procedure is_Modified(p_api_version NUMBER
498 , p_init_msg_list VARCHAR2
499 , p_validation_level NUMBER
500 , x_return_status out nocopy VARCHAR2
501 , x_msg_count out nocopy NUMBER
502 , x_msg_data out nocopy VARCHAR2
503 , p6_a0 in out nocopy NUMBER
504 , p6_a1 in out nocopy VARCHAR2
505 , p6_a2 in out nocopy NUMBER
506 , p6_a3 in out nocopy NUMBER
507 , p6_a4 in out nocopy NUMBER
508 , p6_a5 in out nocopy NUMBER
509 , p6_a6 in out nocopy VARCHAR2
510 , p6_a7 in out nocopy VARCHAR2
511 , p6_a8 in out nocopy VARCHAR2
512 , p6_a9 in out nocopy VARCHAR2
513 , p6_a10 in out nocopy NUMBER
514 , p6_a11 in out nocopy VARCHAR2
515 , p6_a12 in out nocopy DATE
516 , p6_a13 in out nocopy DATE
517 , p6_a14 in out nocopy VARCHAR2
518 , p6_a15 in out nocopy NUMBER
519 , p6_a16 in out nocopy VARCHAR2
520 , p7_a0 in out nocopy NUMBER
521 , p7_a1 in out nocopy NUMBER
522 , p7_a2 in out nocopy NUMBER
523 , p7_a3 in out nocopy NUMBER
524 , p7_a4 in out nocopy NUMBER
525 , p7_a5 in out nocopy NUMBER
526 , p7_a6 in out nocopy VARCHAR2
527 , p7_a7 in out nocopy NUMBER
528 , p7_a8 in out nocopy NUMBER
529 , p7_a9 in out nocopy NUMBER
530 , p7_a10 in out nocopy NUMBER
531 , p7_a11 in out nocopy VARCHAR2
532 , p7_a12 in out nocopy VARCHAR2
533 , p7_a13 in out nocopy NUMBER
534 , p7_a14 in out nocopy DATE
535 , p7_a15 in out nocopy NUMBER
536 , p7_a16 in out nocopy NUMBER
537 , p7_a17 in out nocopy NUMBER
538 , p7_a18 in out nocopy VARCHAR2
539 , p7_a19 in out nocopy VARCHAR2
540 , p7_a20 in out nocopy VARCHAR2
541 , p7_a21 in out nocopy VARCHAR2
542 , p8_a0 in out nocopy JTF_NUMBER_TABLE
543 , p8_a1 in out nocopy JTF_NUMBER_TABLE
544 , p8_a2 in out nocopy JTF_NUMBER_TABLE
545 , p8_a3 in out nocopy JTF_NUMBER_TABLE
546 , p8_a4 in out nocopy JTF_NUMBER_TABLE
547 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
548 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
549 , p8_a7 in out nocopy JTF_NUMBER_TABLE
550 , p8_a8 in out nocopy JTF_NUMBER_TABLE
551 , p8_a9 in out nocopy JTF_NUMBER_TABLE
552 , p8_a10 in out nocopy JTF_NUMBER_TABLE
553 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
554 );
555
556 procedure ini_recipient_validate(p_api_version NUMBER
557 , p_init_msg_list VARCHAR2
558 , p_validation_level NUMBER
559 , x_return_status out nocopy VARCHAR2
560 , x_msg_count out nocopy NUMBER
561 , x_msg_data out nocopy VARCHAR2
562 , p6_a0 in out nocopy NUMBER
563 , p6_a1 in out nocopy VARCHAR2
564 , p6_a2 in out nocopy NUMBER
565 , p6_a3 in out nocopy NUMBER
566 , p6_a4 in out nocopy NUMBER
567 , p6_a5 in out nocopy NUMBER
568 , p6_a6 in out nocopy VARCHAR2
569 , p6_a7 in out nocopy VARCHAR2
570 , p6_a8 in out nocopy VARCHAR2
571 , p6_a9 in out nocopy VARCHAR2
572 , p6_a10 in out nocopy NUMBER
573 , p6_a11 in out nocopy VARCHAR2
574 , p6_a12 in out nocopy DATE
575 , p6_a13 in out nocopy DATE
576 , p6_a14 in out nocopy VARCHAR2
577 , p6_a15 in out nocopy NUMBER
578 , p6_a16 in out nocopy VARCHAR2
579 , p7_a0 in out nocopy NUMBER
580 , p7_a1 in out nocopy NUMBER
581 , p7_a2 in out nocopy NUMBER
582 , p7_a3 in out nocopy NUMBER
583 , p7_a4 in out nocopy NUMBER
584 , p7_a5 in out nocopy NUMBER
585 , p7_a6 in out nocopy VARCHAR2
586 , p7_a7 in out nocopy NUMBER
587 , p7_a8 in out nocopy NUMBER
588 , p7_a9 in out nocopy NUMBER
589 , p7_a10 in out nocopy NUMBER
590 , p7_a11 in out nocopy VARCHAR2
591 , p7_a12 in out nocopy VARCHAR2
592 , p7_a13 in out nocopy NUMBER
593 , p7_a14 in out nocopy DATE
594 , p7_a15 in out nocopy NUMBER
595 , p7_a16 in out nocopy NUMBER
596 , p7_a17 in out nocopy NUMBER
597 , p7_a18 in out nocopy VARCHAR2
598 , p7_a19 in out nocopy VARCHAR2
599 , p7_a20 in out nocopy VARCHAR2
600 , p7_a21 in out nocopy VARCHAR2
601 , p8_a0 in out nocopy JTF_NUMBER_TABLE
602 , p8_a1 in out nocopy JTF_NUMBER_TABLE
603 , p8_a2 in out nocopy JTF_NUMBER_TABLE
604 , p8_a3 in out nocopy JTF_NUMBER_TABLE
605 , p8_a4 in out nocopy JTF_NUMBER_TABLE
606 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
607 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_100
608 , p8_a7 in out nocopy JTF_NUMBER_TABLE
609 , p8_a8 in out nocopy JTF_NUMBER_TABLE
610 , p8_a9 in out nocopy JTF_NUMBER_TABLE
611 , p8_a10 in out nocopy JTF_NUMBER_TABLE
612 , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
613 );
614 function isOldDistId(distId number) return varchar2;
615 end fun_trx_pvt_w;