1: package cn_wksht_get_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwwkgts.pls 115.17 2003/06/27 20:36:34 achung ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_wksht_get_pub.wksht_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package cn_wksht_get_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwwkgts.pls 115.17 2003/06/27 20:36:34 achung ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_wksht_get_pub.wksht_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: cnwwkgts.pls 115.17 2003/06/27 20:36:34 achung ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_wksht_get_pub.wksht_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , p_unassigned VARCHAR2
65: , p_worksheet_status VARCHAR2
66: , p_currency_code VARCHAR2
67: , p_order_by VARCHAR2
68: , p18_a0 out nocopy JTF_NUMBER_TABLE
69: , p18_a1 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , p_worksheet_status VARCHAR2
66: , p_currency_code VARCHAR2
67: , p_order_by VARCHAR2
68: , p18_a0 out nocopy JTF_NUMBER_TABLE
69: , p18_a1 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
67: , p_order_by VARCHAR2
68: , p18_a0 out nocopy JTF_NUMBER_TABLE
69: , p18_a1 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
69: , p18_a1 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100