1: package ams_dm_model_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdmms.pls 115.7 2002/11/16 00:07:09 nyostos noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_model_pvt.dm_model_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package ams_dm_model_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdmms.pls 115.7 2002/11/16 00:07:09 nyostos noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_model_pvt.dm_model_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_model_pvt.dm_model_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_4000
35: , a32 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_4000
35: , a32 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_4000
35: , a32 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_VARCHAR2_TABLE_4000
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_300
41: , a38 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_4000
35: , a32 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_VARCHAR2_TABLE_4000
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_300
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_VARCHAR2_TABLE_4000
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_300
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_300
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_200
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200
55: , a52 JTF_VARCHAR2_TABLE_200
56: , a53 JTF_VARCHAR2_TABLE_200
57: , a54 JTF_VARCHAR2_TABLE_200
58: );
59: procedure rosetta_table_copy_out_p3(t ams_dm_model_pvt.dm_model_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
60: , a1 OUT NOCOPY JTF_DATE_TABLE
61: , a2 OUT NOCOPY JTF_NUMBER_TABLE
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
57: , a54 JTF_VARCHAR2_TABLE_200
58: );
59: procedure rosetta_table_copy_out_p3(t ams_dm_model_pvt.dm_model_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
60: , a1 OUT NOCOPY JTF_DATE_TABLE
61: , a2 OUT NOCOPY JTF_NUMBER_TABLE
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
59: procedure rosetta_table_copy_out_p3(t ams_dm_model_pvt.dm_model_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
60: , a1 OUT NOCOPY JTF_DATE_TABLE
61: , a2 OUT NOCOPY JTF_NUMBER_TABLE
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
66: , a7 OUT NOCOPY JTF_NUMBER_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
60: , a1 OUT NOCOPY JTF_DATE_TABLE
61: , a2 OUT NOCOPY JTF_NUMBER_TABLE
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
66: , a7 OUT NOCOPY JTF_NUMBER_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a2 OUT NOCOPY JTF_NUMBER_TABLE
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
66: , a7 OUT NOCOPY JTF_NUMBER_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 OUT NOCOPY JTF_NUMBER_TABLE
69: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a3 OUT NOCOPY JTF_DATE_TABLE
63: , a4 OUT NOCOPY JTF_NUMBER_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
66: , a7 OUT NOCOPY JTF_NUMBER_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 OUT NOCOPY JTF_NUMBER_TABLE
69: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
70: , a11 OUT NOCOPY JTF_DATE_TABLE
64: , a5 OUT NOCOPY JTF_NUMBER_TABLE
65: , a6 OUT NOCOPY JTF_NUMBER_TABLE
66: , a7 OUT NOCOPY JTF_NUMBER_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 OUT NOCOPY JTF_NUMBER_TABLE
69: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
70: , a11 OUT NOCOPY JTF_DATE_TABLE
71: , a12 OUT NOCOPY JTF_NUMBER_TABLE
72: , a13 OUT NOCOPY JTF_DATE_TABLE
67: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 OUT NOCOPY JTF_NUMBER_TABLE
69: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
70: , a11 OUT NOCOPY JTF_DATE_TABLE
71: , a12 OUT NOCOPY JTF_NUMBER_TABLE
72: , a13 OUT NOCOPY JTF_DATE_TABLE
73: , a14 OUT NOCOPY JTF_DATE_TABLE
74: , a15 OUT NOCOPY JTF_NUMBER_TABLE
75: , a16 OUT NOCOPY JTF_DATE_TABLE
70: , a11 OUT NOCOPY JTF_DATE_TABLE
71: , a12 OUT NOCOPY JTF_NUMBER_TABLE
72: , a13 OUT NOCOPY JTF_DATE_TABLE
73: , a14 OUT NOCOPY JTF_DATE_TABLE
74: , a15 OUT NOCOPY JTF_NUMBER_TABLE
75: , a16 OUT NOCOPY JTF_DATE_TABLE
76: , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
79: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
81: , a22 OUT NOCOPY JTF_NUMBER_TABLE
82: , a23 OUT NOCOPY JTF_NUMBER_TABLE
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
79: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
81: , a22 OUT NOCOPY JTF_NUMBER_TABLE
82: , a23 OUT NOCOPY JTF_NUMBER_TABLE
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
79: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
81: , a22 OUT NOCOPY JTF_NUMBER_TABLE
82: , a23 OUT NOCOPY JTF_NUMBER_TABLE
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
87: , a28 OUT NOCOPY JTF_NUMBER_TABLE
80: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
81: , a22 OUT NOCOPY JTF_NUMBER_TABLE
82: , a23 OUT NOCOPY JTF_NUMBER_TABLE
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
87: , a28 OUT NOCOPY JTF_NUMBER_TABLE
88: , a29 OUT NOCOPY JTF_NUMBER_TABLE
82: , a23 OUT NOCOPY JTF_NUMBER_TABLE
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
87: , a28 OUT NOCOPY JTF_NUMBER_TABLE
88: , a29 OUT NOCOPY JTF_NUMBER_TABLE
89: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_100
90: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
83: , a24 OUT NOCOPY JTF_NUMBER_TABLE
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
87: , a28 OUT NOCOPY JTF_NUMBER_TABLE
88: , a29 OUT NOCOPY JTF_NUMBER_TABLE
89: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_100
90: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
91: , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
84: , a25 OUT NOCOPY JTF_NUMBER_TABLE
85: , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_100
86: , a27 OUT NOCOPY JTF_NUMBER_TABLE
87: , a28 OUT NOCOPY JTF_NUMBER_TABLE
88: , a29 OUT NOCOPY JTF_NUMBER_TABLE
89: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_100
90: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
91: , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
92: , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
89: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_100
90: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
91: , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
92: , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
93: , a34 OUT NOCOPY JTF_NUMBER_TABLE
94: , a35 OUT NOCOPY JTF_NUMBER_TABLE
95: , a36 OUT NOCOPY JTF_NUMBER_TABLE
96: , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_300
97: , a38 OUT NOCOPY JTF_NUMBER_TABLE
90: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
91: , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
92: , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
93: , a34 OUT NOCOPY JTF_NUMBER_TABLE
94: , a35 OUT NOCOPY JTF_NUMBER_TABLE
95: , a36 OUT NOCOPY JTF_NUMBER_TABLE
96: , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_300
97: , a38 OUT NOCOPY JTF_NUMBER_TABLE
98: , a39 OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
92: , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
93: , a34 OUT NOCOPY JTF_NUMBER_TABLE
94: , a35 OUT NOCOPY JTF_NUMBER_TABLE
95: , a36 OUT NOCOPY JTF_NUMBER_TABLE
96: , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_300
97: , a38 OUT NOCOPY JTF_NUMBER_TABLE
98: , a39 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a40 OUT NOCOPY JTF_VARCHAR2_TABLE_200
93: , a34 OUT NOCOPY JTF_NUMBER_TABLE
94: , a35 OUT NOCOPY JTF_NUMBER_TABLE
95: , a36 OUT NOCOPY JTF_NUMBER_TABLE
96: , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_300
97: , a38 OUT NOCOPY JTF_NUMBER_TABLE
98: , a39 OUT NOCOPY JTF_VARCHAR2_TABLE_100
99: , a40 OUT NOCOPY JTF_VARCHAR2_TABLE_200
100: , a41 OUT NOCOPY JTF_VARCHAR2_TABLE_200
101: , a42 OUT NOCOPY JTF_VARCHAR2_TABLE_200