1: package iex_score_pub_w AUTHID CURRENT_USER as
2: /* $Header: iexwscrs.pls 120.6 2004/11/08 19:20:19 clchang ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
1: package iex_score_pub_w AUTHID CURRENT_USER as
2: /* $Header: iexwscrs.pls 120.6 2004/11/08 19:20:19 clchang ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: );
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: );
8: procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_NUMBER_TABLE
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
12: );
10: , a2 out nocopy JTF_NUMBER_TABLE
11: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
12: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy iex_score_pub.score_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_VARCHAR2_TABLE_300
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_NUMBER_TABLE
18: , a4 JTF_DATE_TABLE
36: , a22 JTF_VARCHAR2_TABLE_1000
37: , a23 JTF_VARCHAR2_TABLE_1000
38: , a24 JTF_VARCHAR2_TABLE_100
39: );
40: procedure rosetta_table_copy_out_p3(t iex_score_pub.score_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_300
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
63: , a23 out nocopy JTF_VARCHAR2_TABLE_1000
64: , a24 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p7(t out nocopy iex_score_pub.score_comp_tbl_type, a0 JTF_NUMBER_TABLE
68: , a1 JTF_NUMBER_TABLE
69: , a2 JTF_NUMBER_TABLE
70: , a3 JTF_VARCHAR2_TABLE_100
71: , a4 JTF_NUMBER_TABLE
74: , a7 JTF_DATE_TABLE
75: , a8 JTF_NUMBER_TABLE
76: , a9 JTF_NUMBER_TABLE
77: );
78: procedure rosetta_table_copy_out_p7(t iex_score_pub.score_comp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , a4 out nocopy JTF_NUMBER_TABLE
86: , a8 out nocopy JTF_NUMBER_TABLE
87: , a9 out nocopy JTF_NUMBER_TABLE
88: );
89:
90: procedure rosetta_table_copy_in_p11(t out nocopy iex_score_pub.score_comp_det_tbl_type, a0 JTF_NUMBER_TABLE
91: , a1 JTF_NUMBER_TABLE
92: , a2 JTF_NUMBER_TABLE
93: , a3 JTF_NUMBER_TABLE
94: , a4 JTF_VARCHAR2_TABLE_2000
100: , a10 JTF_DATE_TABLE
101: , a11 JTF_NUMBER_TABLE
102: , a12 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p11(t iex_score_pub.score_comp_det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
115: , a11 out nocopy JTF_NUMBER_TABLE
116: , a12 out nocopy JTF_NUMBER_TABLE
117: );
118:
119: procedure rosetta_table_copy_in_p15(t out nocopy iex_score_pub.score_comp_type_tbl_type, a0 JTF_NUMBER_TABLE
120: , a1 JTF_NUMBER_TABLE
121: , a2 JTF_NUMBER_TABLE
122: , a3 JTF_NUMBER_TABLE
123: , a4 JTF_DATE_TABLE
134: , a15 JTF_VARCHAR2_TABLE_100
135: , a16 JTF_VARCHAR2_TABLE_100
136: , a17 JTF_NUMBER_TABLE
137: );
138: procedure rosetta_table_copy_out_p15(t iex_score_pub.score_comp_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_NUMBER_TABLE
140: , a2 out nocopy JTF_NUMBER_TABLE
141: , a3 out nocopy JTF_NUMBER_TABLE
142: , a4 out nocopy JTF_DATE_TABLE
154: , a16 out nocopy JTF_VARCHAR2_TABLE_100
155: , a17 out nocopy JTF_NUMBER_TABLE
156: );
157:
158: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE);
159: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
160:
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
155: , a17 out nocopy JTF_NUMBER_TABLE
156: );
157:
158: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE);
159: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
160:
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163:
157:
158: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE);
159: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
160:
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE);
165: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
158: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE);
159: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
160:
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE);
165: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
166:
160:
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE);
165: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
166:
167: procedure create_score(p_api_version NUMBER
168: , p_init_msg_list VARCHAR2
161: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163:
164: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE);
165: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
166:
167: procedure create_score(p_api_version NUMBER
168: , p_init_msg_list VARCHAR2
169: , p_commit VARCHAR2
409: , x_return_status out nocopy VARCHAR2
410: , x_msg_count out nocopy NUMBER
411: , x_msg_data out nocopy VARCHAR2
412: );
413: end iex_score_pub_w;