1: package ams_dm_score_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdmss.pls 120.1 2005/06/15 23:58:35 appldev $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_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_score_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdmss.pls 120.1 2005/06/15 23:58:35 appldev $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_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_score_pvt.dm_score_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_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_NUMBER_TABLE
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_NUMBER_TABLE
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_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 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_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_1000
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_1000
34: , a31 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_200
48: , a45 JTF_VARCHAR2_TABLE_200
49: , a46 JTF_VARCHAR2_TABLE_200
50: );
51: procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY JTF_DATE_TABLE
53: , a2 OUT NOCOPY JTF_NUMBER_TABLE
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_200
50: );
51: procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY JTF_DATE_TABLE
53: , a2 OUT NOCOPY JTF_NUMBER_TABLE
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
51: procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY JTF_DATE_TABLE
53: , a2 OUT NOCOPY JTF_NUMBER_TABLE
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY JTF_DATE_TABLE
53: , a2 OUT NOCOPY JTF_NUMBER_TABLE
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
53: , a2 OUT NOCOPY JTF_NUMBER_TABLE
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
54: , a3 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a11 OUT NOCOPY JTF_DATE_TABLE
55: , a4 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a11 OUT NOCOPY JTF_DATE_TABLE
63: , a12 OUT NOCOPY JTF_NUMBER_TABLE
56: , a5 OUT NOCOPY JTF_NUMBER_TABLE
57: , a6 OUT NOCOPY JTF_NUMBER_TABLE
58: , a7 OUT NOCOPY JTF_NUMBER_TABLE
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a11 OUT NOCOPY JTF_DATE_TABLE
63: , a12 OUT NOCOPY JTF_NUMBER_TABLE
64: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
59: , a8 OUT NOCOPY JTF_NUMBER_TABLE
60: , a9 OUT NOCOPY JTF_NUMBER_TABLE
61: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62: , a11 OUT NOCOPY JTF_DATE_TABLE
63: , a12 OUT NOCOPY JTF_NUMBER_TABLE
64: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a15 OUT NOCOPY JTF_DATE_TABLE
67: , a16 OUT NOCOPY JTF_NUMBER_TABLE
63: , a12 OUT NOCOPY JTF_NUMBER_TABLE
64: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: , a15 OUT NOCOPY JTF_DATE_TABLE
67: , a16 OUT NOCOPY JTF_NUMBER_TABLE
68: , a17 OUT NOCOPY JTF_DATE_TABLE
69: , a18 OUT NOCOPY JTF_DATE_TABLE
70: , a19 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
66: , a15 OUT NOCOPY JTF_DATE_TABLE
67: , a16 OUT NOCOPY JTF_NUMBER_TABLE
68: , a17 OUT NOCOPY JTF_DATE_TABLE
69: , a18 OUT NOCOPY JTF_DATE_TABLE
70: , a19 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
67: , a16 OUT NOCOPY JTF_NUMBER_TABLE
68: , a17 OUT NOCOPY JTF_DATE_TABLE
69: , a18 OUT NOCOPY JTF_DATE_TABLE
70: , a19 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
68: , a17 OUT NOCOPY JTF_DATE_TABLE
69: , a18 OUT NOCOPY JTF_DATE_TABLE
70: , a19 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
69: , a18 OUT NOCOPY JTF_DATE_TABLE
70: , a19 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
77: , a26 OUT NOCOPY JTF_NUMBER_TABLE
71: , a20 OUT NOCOPY JTF_NUMBER_TABLE
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
77: , a26 OUT NOCOPY JTF_NUMBER_TABLE
78: , a27 OUT NOCOPY JTF_NUMBER_TABLE
79: , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
72: , a21 OUT NOCOPY JTF_NUMBER_TABLE
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
77: , a26 OUT NOCOPY JTF_NUMBER_TABLE
78: , a27 OUT NOCOPY JTF_NUMBER_TABLE
79: , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
80: , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
73: , a22 OUT NOCOPY JTF_NUMBER_TABLE
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
77: , a26 OUT NOCOPY JTF_NUMBER_TABLE
78: , a27 OUT NOCOPY JTF_NUMBER_TABLE
79: , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
80: , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
81: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
74: , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75: , a24 OUT NOCOPY JTF_NUMBER_TABLE
76: , a25 OUT NOCOPY JTF_NUMBER_TABLE
77: , a26 OUT NOCOPY JTF_NUMBER_TABLE
78: , a27 OUT NOCOPY JTF_NUMBER_TABLE
79: , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
80: , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
81: , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
82: , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_100