1: package okl_aet_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIAETS.pls 120.2 2005/12/02 12:56:30 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
41:
42: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
127: , x_msg_data out nocopy VARCHAR2
128: , p5_a0 JTF_NUMBER_TABLE
129: , p5_a1 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
325: , x_msg_data out nocopy VARCHAR2
326: , p5_a0 JTF_NUMBER_TABLE
327: , p5_a1 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE