1: package iex_score_pub_w 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: );
1: package iex_score_pub_w 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: );
8: procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE
1: package iex_score_pub_w 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: );
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
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: );
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: );
13:
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: );
13:
14: procedure rosetta_table_copy_in_p3(t out nocopy iex_score_pub.score_tbl_type, a0 JTF_NUMBER_TABLE
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
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
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_200
15: , a1 JTF_VARCHAR2_TABLE_300
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_NUMBER_TABLE
18: , a4 JTF_DATE_TABLE
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_200
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_DATE_TABLE
16: , a2 JTF_DATE_TABLE
17: , a3 JTF_NUMBER_TABLE
18: , a4 JTF_DATE_TABLE
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_200
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_DATE_TABLE
24: , a10 JTF_DATE_TABLE
21: , a7 JTF_VARCHAR2_TABLE_200
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_DATE_TABLE
24: , a10 JTF_DATE_TABLE
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
23: , a9 JTF_DATE_TABLE
24: , a10 JTF_DATE_TABLE
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_NUMBER_TABLE
25: , a11 JTF_NUMBER_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_NUMBER_TABLE
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_NUMBER_TABLE
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_DATE_TABLE
34: , a20 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_NUMBER_TABLE
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_NUMBER_TABLE
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_DATE_TABLE
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
28: , a14 JTF_VARCHAR2_TABLE_100
29: , a15 JTF_NUMBER_TABLE
30: , a16 JTF_NUMBER_TABLE
31: , a17 JTF_NUMBER_TABLE
32: , a18 JTF_NUMBER_TABLE
33: , a19 JTF_DATE_TABLE
34: , a20 JTF_VARCHAR2_TABLE_100
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_1000
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
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
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
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
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_200
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_DATE_TABLE
51: , a11 out nocopy JTF_NUMBER_TABLE
52: , a12 out nocopy JTF_VARCHAR2_TABLE_100
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_DATE_TABLE
51: , a11 out nocopy JTF_NUMBER_TABLE
52: , a12 out nocopy JTF_VARCHAR2_TABLE_100
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
56: , a16 out nocopy JTF_NUMBER_TABLE
57: , a17 out nocopy JTF_NUMBER_TABLE
51: , a11 out nocopy JTF_NUMBER_TABLE
52: , a12 out nocopy JTF_VARCHAR2_TABLE_100
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
56: , a16 out nocopy JTF_NUMBER_TABLE
57: , a17 out nocopy JTF_NUMBER_TABLE
58: , a18 out nocopy JTF_NUMBER_TABLE
59: , a19 out nocopy JTF_DATE_TABLE
52: , a12 out nocopy JTF_VARCHAR2_TABLE_100
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
56: , a16 out nocopy JTF_NUMBER_TABLE
57: , a17 out nocopy JTF_NUMBER_TABLE
58: , a18 out nocopy JTF_NUMBER_TABLE
59: , a19 out nocopy JTF_DATE_TABLE
60: , a20 out nocopy JTF_VARCHAR2_TABLE_100
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
56: , a16 out nocopy JTF_NUMBER_TABLE
57: , a17 out nocopy JTF_NUMBER_TABLE
58: , a18 out nocopy JTF_NUMBER_TABLE
59: , a19 out nocopy JTF_DATE_TABLE
60: , a20 out nocopy JTF_VARCHAR2_TABLE_100
61: , a21 out nocopy JTF_VARCHAR2_TABLE_100
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_NUMBER_TABLE
56: , a16 out nocopy JTF_NUMBER_TABLE
57: , a17 out nocopy JTF_NUMBER_TABLE
58: , a18 out nocopy JTF_NUMBER_TABLE
59: , a19 out nocopy JTF_DATE_TABLE
60: , a20 out nocopy JTF_VARCHAR2_TABLE_100
61: , a21 out nocopy JTF_VARCHAR2_TABLE_100
62: , a22 out nocopy JTF_VARCHAR2_TABLE_1000
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
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
72: , a5 JTF_DATE_TABLE
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
72: , a5 JTF_DATE_TABLE
73: , a6 JTF_NUMBER_TABLE
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
72: , a5 JTF_DATE_TABLE
73: , a6 JTF_NUMBER_TABLE
74: , a7 JTF_DATE_TABLE
75: , a8 JTF_NUMBER_TABLE
69: , a2 JTF_NUMBER_TABLE
70: , a3 JTF_VARCHAR2_TABLE_100
71: , a4 JTF_NUMBER_TABLE
72: , a5 JTF_DATE_TABLE
73: , a6 JTF_NUMBER_TABLE
74: , a7 JTF_DATE_TABLE
75: , a8 JTF_NUMBER_TABLE
76: , a9 JTF_NUMBER_TABLE
77: );
71: , a4 JTF_NUMBER_TABLE
72: , a5 JTF_DATE_TABLE
73: , a6 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
72: , a5 JTF_DATE_TABLE
73: , a6 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
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
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
83: , a5 out nocopy JTF_DATE_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
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_NUMBER_TABLE
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
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_DATE_TABLE
86: , a8 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
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_DATE_TABLE
86: , a8 out nocopy JTF_NUMBER_TABLE
87: , a9 out nocopy JTF_NUMBER_TABLE
88: );
82: , a4 out nocopy JTF_NUMBER_TABLE
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_DATE_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
83: , a5 out nocopy JTF_DATE_TABLE
84: , a6 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_DATE_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
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
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
95: , a5 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
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
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
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
97: , a7 JTF_NUMBER_TABLE
91: , a1 JTF_NUMBER_TABLE
92: , a2 JTF_NUMBER_TABLE
93: , a3 JTF_NUMBER_TABLE
94: , a4 JTF_VARCHAR2_TABLE_2000
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
97: , a7 JTF_NUMBER_TABLE
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
92: , a2 JTF_NUMBER_TABLE
93: , a3 JTF_NUMBER_TABLE
94: , a4 JTF_VARCHAR2_TABLE_2000
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
97: , a7 JTF_NUMBER_TABLE
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
100: , a10 JTF_DATE_TABLE
93: , a3 JTF_NUMBER_TABLE
94: , a4 JTF_VARCHAR2_TABLE_2000
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
97: , a7 JTF_NUMBER_TABLE
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
100: , a10 JTF_DATE_TABLE
101: , a11 JTF_NUMBER_TABLE
95: , a5 JTF_NUMBER_TABLE
96: , a6 JTF_NUMBER_TABLE
97: , a7 JTF_NUMBER_TABLE
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
100: , a10 JTF_DATE_TABLE
101: , a11 JTF_NUMBER_TABLE
102: , a12 JTF_NUMBER_TABLE
103: );
97: , a7 JTF_NUMBER_TABLE
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
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
98: , a8 JTF_DATE_TABLE
99: , a9 JTF_NUMBER_TABLE
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
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
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
109: , a5 out nocopy 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
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy 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
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 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
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_NUMBER_TABLE
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 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
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_NUMBER_TABLE
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 out nocopy JTF_NUMBER_TABLE
114: , a10 out nocopy JTF_DATE_TABLE
107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_NUMBER_TABLE
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 out nocopy JTF_NUMBER_TABLE
114: , a10 out nocopy JTF_DATE_TABLE
115: , a11 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_NUMBER_TABLE
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_NUMBER_TABLE
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 out nocopy JTF_NUMBER_TABLE
114: , a10 out nocopy JTF_DATE_TABLE
115: , a11 out nocopy JTF_NUMBER_TABLE
116: , a12 out nocopy JTF_NUMBER_TABLE
117: );
111: , a7 out nocopy JTF_NUMBER_TABLE
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 out nocopy JTF_NUMBER_TABLE
114: , a10 out nocopy JTF_DATE_TABLE
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
112: , a8 out nocopy JTF_DATE_TABLE
113: , a9 out nocopy JTF_NUMBER_TABLE
114: , a10 out nocopy JTF_DATE_TABLE
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
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
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
124: , a5 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
124: , a5 JTF_NUMBER_TABLE
125: , a6 JTF_NUMBER_TABLE
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
124: , a5 JTF_NUMBER_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_DATE_TABLE
120: , a1 JTF_NUMBER_TABLE
121: , a2 JTF_NUMBER_TABLE
122: , a3 JTF_NUMBER_TABLE
123: , a4 JTF_DATE_TABLE
124: , a5 JTF_NUMBER_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_DATE_TABLE
127: , a8 JTF_NUMBER_TABLE
128: , a9 JTF_VARCHAR2_TABLE_2000
121: , a2 JTF_NUMBER_TABLE
122: , a3 JTF_NUMBER_TABLE
123: , a4 JTF_DATE_TABLE
124: , a5 JTF_NUMBER_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_DATE_TABLE
127: , a8 JTF_NUMBER_TABLE
128: , a9 JTF_VARCHAR2_TABLE_2000
129: , a10 JTF_VARCHAR2_TABLE_100
123: , a4 JTF_DATE_TABLE
124: , a5 JTF_NUMBER_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_DATE_TABLE
127: , a8 JTF_NUMBER_TABLE
128: , a9 JTF_VARCHAR2_TABLE_2000
129: , a10 JTF_VARCHAR2_TABLE_100
130: , a11 JTF_VARCHAR2_TABLE_100
131: , a12 JTF_VARCHAR2_TABLE_100
132: , a13 JTF_VARCHAR2_TABLE_100
133: , a14 JTF_VARCHAR2_TABLE_100
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
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
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
143: , a5 out nocopy JTF_NUMBER_TABLE
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
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy 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
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE
145: , a7 out nocopy JTF_DATE_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
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE
145: , a7 out nocopy JTF_DATE_TABLE
146: , a8 out nocopy JTF_NUMBER_TABLE
147: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a2 out nocopy JTF_NUMBER_TABLE
141: , a3 out nocopy JTF_NUMBER_TABLE
142: , a4 out nocopy JTF_DATE_TABLE
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE
145: , a7 out nocopy JTF_DATE_TABLE
146: , a8 out nocopy JTF_NUMBER_TABLE
147: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a4 out nocopy JTF_DATE_TABLE
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE
145: , a7 out nocopy JTF_DATE_TABLE
146: , a8 out nocopy JTF_NUMBER_TABLE
147: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a10 out nocopy JTF_VARCHAR2_TABLE_100
149: , a11 out nocopy JTF_VARCHAR2_TABLE_100
150: , a12 out nocopy JTF_VARCHAR2_TABLE_100
151: , a13 out nocopy JTF_VARCHAR2_TABLE_100
152: , a14 out nocopy JTF_VARCHAR2_TABLE_100
153: , a15 out nocopy JTF_VARCHAR2_TABLE_100
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);
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
200: );
201: procedure update_score(p_api_version NUMBER
202: , p_init_msg_list VARCHAR2
203: , p_commit VARCHAR2
204: , p3_a0 JTF_NUMBER_TABLE
205: , p3_a1 JTF_VARCHAR2_TABLE_300
206: , p3_a2 JTF_DATE_TABLE
207: , p3_a3 JTF_NUMBER_TABLE
208: , p3_a4 JTF_DATE_TABLE
203: , p_commit VARCHAR2
204: , p3_a0 JTF_NUMBER_TABLE
205: , p3_a1 JTF_VARCHAR2_TABLE_300
206: , p3_a2 JTF_DATE_TABLE
207: , p3_a3 JTF_NUMBER_TABLE
208: , p3_a4 JTF_DATE_TABLE
209: , p3_a5 JTF_NUMBER_TABLE
210: , p3_a6 JTF_NUMBER_TABLE
211: , p3_a7 JTF_VARCHAR2_TABLE_200
205: , p3_a1 JTF_VARCHAR2_TABLE_300
206: , p3_a2 JTF_DATE_TABLE
207: , p3_a3 JTF_NUMBER_TABLE
208: , p3_a4 JTF_DATE_TABLE
209: , p3_a5 JTF_NUMBER_TABLE
210: , p3_a6 JTF_NUMBER_TABLE
211: , p3_a7 JTF_VARCHAR2_TABLE_200
212: , p3_a8 JTF_VARCHAR2_TABLE_100
213: , p3_a9 JTF_DATE_TABLE
206: , p3_a2 JTF_DATE_TABLE
207: , p3_a3 JTF_NUMBER_TABLE
208: , p3_a4 JTF_DATE_TABLE
209: , p3_a5 JTF_NUMBER_TABLE
210: , p3_a6 JTF_NUMBER_TABLE
211: , p3_a7 JTF_VARCHAR2_TABLE_200
212: , p3_a8 JTF_VARCHAR2_TABLE_100
213: , p3_a9 JTF_DATE_TABLE
214: , p3_a10 JTF_DATE_TABLE
211: , p3_a7 JTF_VARCHAR2_TABLE_200
212: , p3_a8 JTF_VARCHAR2_TABLE_100
213: , p3_a9 JTF_DATE_TABLE
214: , p3_a10 JTF_DATE_TABLE
215: , p3_a11 JTF_NUMBER_TABLE
216: , p3_a12 JTF_VARCHAR2_TABLE_100
217: , p3_a13 JTF_NUMBER_TABLE
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
213: , p3_a9 JTF_DATE_TABLE
214: , p3_a10 JTF_DATE_TABLE
215: , p3_a11 JTF_NUMBER_TABLE
216: , p3_a12 JTF_VARCHAR2_TABLE_100
217: , p3_a13 JTF_NUMBER_TABLE
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
220: , p3_a16 JTF_NUMBER_TABLE
221: , p3_a17 JTF_NUMBER_TABLE
215: , p3_a11 JTF_NUMBER_TABLE
216: , p3_a12 JTF_VARCHAR2_TABLE_100
217: , p3_a13 JTF_NUMBER_TABLE
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
220: , p3_a16 JTF_NUMBER_TABLE
221: , p3_a17 JTF_NUMBER_TABLE
222: , p3_a18 JTF_NUMBER_TABLE
223: , p3_a19 JTF_DATE_TABLE
216: , p3_a12 JTF_VARCHAR2_TABLE_100
217: , p3_a13 JTF_NUMBER_TABLE
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
220: , p3_a16 JTF_NUMBER_TABLE
221: , p3_a17 JTF_NUMBER_TABLE
222: , p3_a18 JTF_NUMBER_TABLE
223: , p3_a19 JTF_DATE_TABLE
224: , p3_a20 JTF_VARCHAR2_TABLE_100
217: , p3_a13 JTF_NUMBER_TABLE
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
220: , p3_a16 JTF_NUMBER_TABLE
221: , p3_a17 JTF_NUMBER_TABLE
222: , p3_a18 JTF_NUMBER_TABLE
223: , p3_a19 JTF_DATE_TABLE
224: , p3_a20 JTF_VARCHAR2_TABLE_100
225: , p3_a21 JTF_VARCHAR2_TABLE_100
218: , p3_a14 JTF_VARCHAR2_TABLE_100
219: , p3_a15 JTF_NUMBER_TABLE
220: , p3_a16 JTF_NUMBER_TABLE
221: , p3_a17 JTF_NUMBER_TABLE
222: , p3_a18 JTF_NUMBER_TABLE
223: , p3_a19 JTF_DATE_TABLE
224: , p3_a20 JTF_VARCHAR2_TABLE_100
225: , p3_a21 JTF_VARCHAR2_TABLE_100
226: , p3_a22 JTF_VARCHAR2_TABLE_1000
233: );
234: procedure delete_score(p_api_version NUMBER
235: , p_init_msg_list VARCHAR2
236: , p_commit VARCHAR2
237: , p_score_id_tbl JTF_NUMBER_TABLE
238: , x_return_status out nocopy VARCHAR2
239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: );
259: );
260: procedure update_score_comp(p_api_version NUMBER
261: , p_init_msg_list VARCHAR2
262: , p_commit VARCHAR2
263: , p3_a0 JTF_NUMBER_TABLE
264: , p3_a1 JTF_NUMBER_TABLE
265: , p3_a2 JTF_NUMBER_TABLE
266: , p3_a3 JTF_VARCHAR2_TABLE_100
267: , p3_a4 JTF_NUMBER_TABLE
260: procedure update_score_comp(p_api_version NUMBER
261: , p_init_msg_list VARCHAR2
262: , p_commit VARCHAR2
263: , p3_a0 JTF_NUMBER_TABLE
264: , p3_a1 JTF_NUMBER_TABLE
265: , p3_a2 JTF_NUMBER_TABLE
266: , p3_a3 JTF_VARCHAR2_TABLE_100
267: , p3_a4 JTF_NUMBER_TABLE
268: , p3_a5 JTF_DATE_TABLE
261: , p_init_msg_list VARCHAR2
262: , p_commit VARCHAR2
263: , p3_a0 JTF_NUMBER_TABLE
264: , p3_a1 JTF_NUMBER_TABLE
265: , p3_a2 JTF_NUMBER_TABLE
266: , p3_a3 JTF_VARCHAR2_TABLE_100
267: , p3_a4 JTF_NUMBER_TABLE
268: , p3_a5 JTF_DATE_TABLE
269: , p3_a6 JTF_NUMBER_TABLE
263: , p3_a0 JTF_NUMBER_TABLE
264: , p3_a1 JTF_NUMBER_TABLE
265: , p3_a2 JTF_NUMBER_TABLE
266: , p3_a3 JTF_VARCHAR2_TABLE_100
267: , p3_a4 JTF_NUMBER_TABLE
268: , p3_a5 JTF_DATE_TABLE
269: , p3_a6 JTF_NUMBER_TABLE
270: , p3_a7 JTF_DATE_TABLE
271: , p3_a8 JTF_NUMBER_TABLE
265: , p3_a2 JTF_NUMBER_TABLE
266: , p3_a3 JTF_VARCHAR2_TABLE_100
267: , p3_a4 JTF_NUMBER_TABLE
268: , p3_a5 JTF_DATE_TABLE
269: , p3_a6 JTF_NUMBER_TABLE
270: , p3_a7 JTF_DATE_TABLE
271: , p3_a8 JTF_NUMBER_TABLE
272: , p3_a9 JTF_NUMBER_TABLE
273: , x_return_status out nocopy VARCHAR2
267: , p3_a4 JTF_NUMBER_TABLE
268: , p3_a5 JTF_DATE_TABLE
269: , p3_a6 JTF_NUMBER_TABLE
270: , p3_a7 JTF_DATE_TABLE
271: , p3_a8 JTF_NUMBER_TABLE
272: , p3_a9 JTF_NUMBER_TABLE
273: , x_return_status out nocopy VARCHAR2
274: , x_msg_count out nocopy NUMBER
275: , x_msg_data out nocopy VARCHAR2
268: , p3_a5 JTF_DATE_TABLE
269: , p3_a6 JTF_NUMBER_TABLE
270: , p3_a7 JTF_DATE_TABLE
271: , p3_a8 JTF_NUMBER_TABLE
272: , p3_a9 JTF_NUMBER_TABLE
273: , x_return_status out nocopy VARCHAR2
274: , x_msg_count out nocopy NUMBER
275: , x_msg_data out nocopy VARCHAR2
276: );
277: procedure delete_score_comp(p_api_version NUMBER
278: , p_init_msg_list VARCHAR2
279: , p_commit VARCHAR2
280: , p_score_id NUMBER
281: , p_score_comp_id_tbl JTF_NUMBER_TABLE
282: , x_return_status out nocopy VARCHAR2
283: , x_msg_count out nocopy NUMBER
284: , x_msg_data out nocopy VARCHAR2
285: );
312: );
313: procedure update_score_comp_type(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
315: , p_commit VARCHAR2
316: , p3_a0 JTF_NUMBER_TABLE
317: , p3_a1 JTF_NUMBER_TABLE
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
313: procedure update_score_comp_type(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
315: , p_commit VARCHAR2
316: , p3_a0 JTF_NUMBER_TABLE
317: , p3_a1 JTF_NUMBER_TABLE
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
314: , p_init_msg_list VARCHAR2
315: , p_commit VARCHAR2
316: , p3_a0 JTF_NUMBER_TABLE
317: , p3_a1 JTF_NUMBER_TABLE
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
322: , p3_a6 JTF_NUMBER_TABLE
315: , p_commit VARCHAR2
316: , p3_a0 JTF_NUMBER_TABLE
317: , p3_a1 JTF_NUMBER_TABLE
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
322: , p3_a6 JTF_NUMBER_TABLE
323: , p3_a7 JTF_DATE_TABLE
317: , p3_a1 JTF_NUMBER_TABLE
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
322: , p3_a6 JTF_NUMBER_TABLE
323: , p3_a7 JTF_DATE_TABLE
324: , p3_a8 JTF_NUMBER_TABLE
325: , p3_a9 JTF_VARCHAR2_TABLE_2000
318: , p3_a2 JTF_NUMBER_TABLE
319: , p3_a3 JTF_NUMBER_TABLE
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
322: , p3_a6 JTF_NUMBER_TABLE
323: , p3_a7 JTF_DATE_TABLE
324: , p3_a8 JTF_NUMBER_TABLE
325: , p3_a9 JTF_VARCHAR2_TABLE_2000
326: , p3_a10 JTF_VARCHAR2_TABLE_100
320: , p3_a4 JTF_DATE_TABLE
321: , p3_a5 JTF_NUMBER_TABLE
322: , p3_a6 JTF_NUMBER_TABLE
323: , p3_a7 JTF_DATE_TABLE
324: , p3_a8 JTF_NUMBER_TABLE
325: , p3_a9 JTF_VARCHAR2_TABLE_2000
326: , p3_a10 JTF_VARCHAR2_TABLE_100
327: , p3_a11 JTF_VARCHAR2_TABLE_100
328: , p3_a12 JTF_VARCHAR2_TABLE_100
329: , p3_a13 JTF_VARCHAR2_TABLE_100
330: , p3_a14 JTF_VARCHAR2_TABLE_100
331: , p3_a15 JTF_VARCHAR2_TABLE_100
332: , p3_a16 JTF_VARCHAR2_TABLE_100
333: , p3_a17 JTF_NUMBER_TABLE
334: , x_dup_status out nocopy VARCHAR2
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: );
339: procedure delete_score_comp_type(p_api_version NUMBER
340: , p_init_msg_list VARCHAR2
341: , p_commit VARCHAR2
342: , p3_a0 JTF_NUMBER_TABLE
343: , p3_a1 JTF_NUMBER_TABLE
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
339: procedure delete_score_comp_type(p_api_version NUMBER
340: , p_init_msg_list VARCHAR2
341: , p_commit VARCHAR2
342: , p3_a0 JTF_NUMBER_TABLE
343: , p3_a1 JTF_NUMBER_TABLE
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
340: , p_init_msg_list VARCHAR2
341: , p_commit VARCHAR2
342: , p3_a0 JTF_NUMBER_TABLE
343: , p3_a1 JTF_NUMBER_TABLE
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
348: , p3_a6 JTF_NUMBER_TABLE
341: , p_commit VARCHAR2
342: , p3_a0 JTF_NUMBER_TABLE
343: , p3_a1 JTF_NUMBER_TABLE
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
348: , p3_a6 JTF_NUMBER_TABLE
349: , p3_a7 JTF_DATE_TABLE
343: , p3_a1 JTF_NUMBER_TABLE
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
348: , p3_a6 JTF_NUMBER_TABLE
349: , p3_a7 JTF_DATE_TABLE
350: , p3_a8 JTF_NUMBER_TABLE
351: , p3_a9 JTF_VARCHAR2_TABLE_2000
344: , p3_a2 JTF_NUMBER_TABLE
345: , p3_a3 JTF_NUMBER_TABLE
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
348: , p3_a6 JTF_NUMBER_TABLE
349: , p3_a7 JTF_DATE_TABLE
350: , p3_a8 JTF_NUMBER_TABLE
351: , p3_a9 JTF_VARCHAR2_TABLE_2000
352: , p3_a10 JTF_VARCHAR2_TABLE_100
346: , p3_a4 JTF_DATE_TABLE
347: , p3_a5 JTF_NUMBER_TABLE
348: , p3_a6 JTF_NUMBER_TABLE
349: , p3_a7 JTF_DATE_TABLE
350: , p3_a8 JTF_NUMBER_TABLE
351: , p3_a9 JTF_VARCHAR2_TABLE_2000
352: , p3_a10 JTF_VARCHAR2_TABLE_100
353: , p3_a11 JTF_VARCHAR2_TABLE_100
354: , p3_a12 JTF_VARCHAR2_TABLE_100
355: , p3_a13 JTF_VARCHAR2_TABLE_100
356: , p3_a14 JTF_VARCHAR2_TABLE_100
357: , p3_a15 JTF_VARCHAR2_TABLE_100
358: , p3_a16 JTF_VARCHAR2_TABLE_100
359: , p3_a17 JTF_NUMBER_TABLE
360: , x_return_status out nocopy VARCHAR2
361: , x_msg_count out nocopy NUMBER
362: , x_msg_data out nocopy VARCHAR2
363: );
363: );
364: procedure create_score_comp_det(p_api_version NUMBER
365: , p_init_msg_list VARCHAR2
366: , p_commit VARCHAR2
367: , p3_a0 in out nocopy JTF_NUMBER_TABLE
368: , p3_a1 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
364: procedure create_score_comp_det(p_api_version NUMBER
365: , p_init_msg_list VARCHAR2
366: , p_commit VARCHAR2
367: , p3_a0 in out nocopy JTF_NUMBER_TABLE
368: , p3_a1 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
365: , p_init_msg_list VARCHAR2
366: , p_commit VARCHAR2
367: , p3_a0 in out nocopy JTF_NUMBER_TABLE
368: , p3_a1 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
366: , p_commit VARCHAR2
367: , p3_a0 in out nocopy JTF_NUMBER_TABLE
368: , p3_a1 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
368: , p3_a1 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
369: , p3_a2 in out nocopy JTF_NUMBER_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
377: , p3_a10 in out nocopy JTF_DATE_TABLE
370: , p3_a3 in out nocopy JTF_NUMBER_TABLE
371: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
377: , p3_a10 in out nocopy JTF_DATE_TABLE
378: , p3_a11 in out nocopy JTF_NUMBER_TABLE
372: , p3_a5 in out nocopy JTF_NUMBER_TABLE
373: , p3_a6 in out nocopy JTF_NUMBER_TABLE
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
377: , p3_a10 in out nocopy JTF_DATE_TABLE
378: , p3_a11 in out nocopy JTF_NUMBER_TABLE
379: , p3_a12 in out nocopy JTF_NUMBER_TABLE
380: , x_return_status out nocopy VARCHAR2
374: , p3_a7 in out nocopy JTF_NUMBER_TABLE
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
377: , p3_a10 in out nocopy JTF_DATE_TABLE
378: , p3_a11 in out nocopy JTF_NUMBER_TABLE
379: , p3_a12 in out nocopy JTF_NUMBER_TABLE
380: , x_return_status out nocopy VARCHAR2
381: , x_msg_count out nocopy NUMBER
382: , x_msg_data out nocopy VARCHAR2
375: , p3_a8 in out nocopy JTF_DATE_TABLE
376: , p3_a9 in out nocopy JTF_NUMBER_TABLE
377: , p3_a10 in out nocopy JTF_DATE_TABLE
378: , p3_a11 in out nocopy JTF_NUMBER_TABLE
379: , p3_a12 in out nocopy JTF_NUMBER_TABLE
380: , x_return_status out nocopy VARCHAR2
381: , x_msg_count out nocopy NUMBER
382: , x_msg_data out nocopy VARCHAR2
383: );
383: );
384: procedure update_score_comp_det(p_api_version NUMBER
385: , p_init_msg_list VARCHAR2
386: , p_commit VARCHAR2
387: , p3_a0 JTF_NUMBER_TABLE
388: , p3_a1 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
384: procedure update_score_comp_det(p_api_version NUMBER
385: , p_init_msg_list VARCHAR2
386: , p_commit VARCHAR2
387: , p3_a0 JTF_NUMBER_TABLE
388: , p3_a1 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
385: , p_init_msg_list VARCHAR2
386: , p_commit VARCHAR2
387: , p3_a0 JTF_NUMBER_TABLE
388: , p3_a1 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
386: , p_commit VARCHAR2
387: , p3_a0 JTF_NUMBER_TABLE
388: , p3_a1 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
394: , p3_a7 JTF_NUMBER_TABLE
388: , p3_a1 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
394: , p3_a7 JTF_NUMBER_TABLE
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
389: , p3_a2 JTF_NUMBER_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
394: , p3_a7 JTF_NUMBER_TABLE
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
397: , p3_a10 JTF_DATE_TABLE
390: , p3_a3 JTF_NUMBER_TABLE
391: , p3_a4 JTF_VARCHAR2_TABLE_2000
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
394: , p3_a7 JTF_NUMBER_TABLE
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
397: , p3_a10 JTF_DATE_TABLE
398: , p3_a11 JTF_NUMBER_TABLE
392: , p3_a5 JTF_NUMBER_TABLE
393: , p3_a6 JTF_NUMBER_TABLE
394: , p3_a7 JTF_NUMBER_TABLE
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
397: , p3_a10 JTF_DATE_TABLE
398: , p3_a11 JTF_NUMBER_TABLE
399: , p3_a12 JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
394: , p3_a7 JTF_NUMBER_TABLE
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
397: , p3_a10 JTF_DATE_TABLE
398: , p3_a11 JTF_NUMBER_TABLE
399: , p3_a12 JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
395: , p3_a8 JTF_DATE_TABLE
396: , p3_a9 JTF_NUMBER_TABLE
397: , p3_a10 JTF_DATE_TABLE
398: , p3_a11 JTF_NUMBER_TABLE
399: , p3_a12 JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: );
404: procedure delete_score_comp_det(p_api_version NUMBER
405: , p_init_msg_list VARCHAR2
406: , p_commit VARCHAR2
407: , p_score_comp_id NUMBER
408: , p_score_comp_det_id_tbl JTF_NUMBER_TABLE
409: , x_return_status out nocopy VARCHAR2
410: , x_msg_count out nocopy NUMBER
411: , x_msg_data out nocopy VARCHAR2
412: );