1: package iem_knowledgebase_pub_w AUTHID CURRENT_USER as
2: /* $Header: IEMVKBSS.pls 115.10 2003/08/04 15:11:04 ukari ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package iem_knowledgebase_pub_w AUTHID CURRENT_USER as
2: /* $Header: IEMVKBSS.pls 115.10 2003/08/04 15:11:04 ukari ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
1: package iem_knowledgebase_pub_w AUTHID CURRENT_USER as
2: /* $Header: IEMVKBSS.pls 115.10 2003/08/04 15:11:04 ukari ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
2: /* $Header: IEMVKBSS.pls 115.10 2003/08/04 15:11:04 ukari ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
10: );
3: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
10: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
10: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
12: , a1 out nocopy JTF_VARCHAR2_TABLE_100
13: , a2 out nocopy JTF_VARCHAR2_TABLE_100
14: , a3 out nocopy JTF_VARCHAR2_TABLE_100
15: , a4 out nocopy JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
10: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
12: , a1 out nocopy JTF_VARCHAR2_TABLE_100
13: , a2 out nocopy JTF_VARCHAR2_TABLE_100
14: , a3 out nocopy JTF_VARCHAR2_TABLE_100
15: , a4 out nocopy JTF_VARCHAR2_TABLE_100
16: , a5 out nocopy JTF_VARCHAR2_TABLE_300
9: , a6 JTF_DATE_TABLE
10: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
12: , a1 out nocopy JTF_VARCHAR2_TABLE_100
13: , a2 out nocopy JTF_VARCHAR2_TABLE_100
14: , a3 out nocopy JTF_VARCHAR2_TABLE_100
15: , a4 out nocopy JTF_VARCHAR2_TABLE_100
16: , a5 out nocopy JTF_VARCHAR2_TABLE_300
17: , a6 out nocopy JTF_DATE_TABLE
10: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
12: , a1 out nocopy JTF_VARCHAR2_TABLE_100
13: , a2 out nocopy JTF_VARCHAR2_TABLE_100
14: , a3 out nocopy JTF_VARCHAR2_TABLE_100
15: , a4 out nocopy JTF_VARCHAR2_TABLE_100
16: , a5 out nocopy JTF_VARCHAR2_TABLE_300
17: , a6 out nocopy JTF_DATE_TABLE
18: );
11: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
12: , a1 out nocopy JTF_VARCHAR2_TABLE_100
13: , a2 out nocopy JTF_VARCHAR2_TABLE_100
14: , a3 out nocopy JTF_VARCHAR2_TABLE_100
15: , a4 out nocopy JTF_VARCHAR2_TABLE_100
16: , a5 out nocopy JTF_VARCHAR2_TABLE_300
17: , a6 out nocopy JTF_DATE_TABLE
18: );
19:
16: , a5 out nocopy JTF_VARCHAR2_TABLE_300
17: , a6 out nocopy JTF_DATE_TABLE
18: );
19:
20: procedure rosetta_table_copy_in_p3(t out nocopy iem_knowledgebase_pub.kbcat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
21: , a1 JTF_VARCHAR2_TABLE_100
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_NUMBER_TABLE
24: , a4 JTF_NUMBER_TABLE
17: , a6 out nocopy JTF_DATE_TABLE
18: );
19:
20: procedure rosetta_table_copy_in_p3(t out nocopy iem_knowledgebase_pub.kbcat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
21: , a1 JTF_VARCHAR2_TABLE_100
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_NUMBER_TABLE
24: , a4 JTF_NUMBER_TABLE
25: );
22: , a2 JTF_NUMBER_TABLE
23: , a3 JTF_NUMBER_TABLE
24: , a4 JTF_NUMBER_TABLE
25: );
26: procedure rosetta_table_copy_out_p3(t iem_knowledgebase_pub.kbcat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_NUMBER_TABLE
23: , a3 JTF_NUMBER_TABLE
24: , a4 JTF_NUMBER_TABLE
25: );
26: procedure rosetta_table_copy_out_p3(t iem_knowledgebase_pub.kbcat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_NUMBER_TABLE
31: );
38: , p_classification_id NUMBER
39: , x_return_status out nocopy VARCHAR2
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , x_return_status out nocopy VARCHAR2
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
40: , x_msg_count out nocopy NUMBER
41: , x_msg_data out nocopy VARCHAR2
42: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , p9_a6 out nocopy JTF_DATE_TABLE
41: , x_msg_data out nocopy VARCHAR2
42: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , p9_a6 out nocopy JTF_DATE_TABLE
49: );
42: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , p9_a6 out nocopy JTF_DATE_TABLE
49: );
50: procedure get_kbcategories(p_api_version_number NUMBER
54: , p_level NUMBER
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER
57: , x_msg_data out nocopy VARCHAR2
58: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
59: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
60: , p8_a2 out nocopy JTF_NUMBER_TABLE
61: , p8_a3 out nocopy JTF_NUMBER_TABLE
62: , p8_a4 out nocopy JTF_NUMBER_TABLE
55: , x_return_status out nocopy VARCHAR2
56: , x_msg_count out nocopy NUMBER
57: , x_msg_data out nocopy VARCHAR2
58: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
59: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
60: , p8_a2 out nocopy JTF_NUMBER_TABLE
61: , p8_a3 out nocopy JTF_NUMBER_TABLE
62: , p8_a4 out nocopy JTF_NUMBER_TABLE
63: );
69: , p_classification_id NUMBER
70: , x_return_status out nocopy VARCHAR2
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , x_return_status out nocopy VARCHAR2
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
79: , p9_a6 out nocopy JTF_DATE_TABLE
72: , x_msg_data out nocopy VARCHAR2
73: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
79: , p9_a6 out nocopy JTF_DATE_TABLE
80: );
73: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
74: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
76: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
77: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
79: , p9_a6 out nocopy JTF_DATE_TABLE
80: );
81: procedure get_suggresponse_dtl(p_api_version_number NUMBER
86: , p_classification_id NUMBER
87: , x_return_status out nocopy VARCHAR2
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
91: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
92: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
87: , x_return_status out nocopy VARCHAR2
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
91: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
92: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
91: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
92: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
96: , p9_a6 out nocopy JTF_DATE_TABLE
89: , x_msg_data out nocopy VARCHAR2
90: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
91: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
92: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
96: , p9_a6 out nocopy JTF_DATE_TABLE
97: );
90: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
91: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
92: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
96: , p9_a6 out nocopy JTF_DATE_TABLE
97: );
98: procedure get_suggresponse_dtl(p_api_version_number NUMBER
102: , p_message_id VARCHAR2
103: , x_return_status out nocopy VARCHAR2
104: , x_msg_count out nocopy NUMBER
105: , x_msg_data out nocopy VARCHAR2
106: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , x_return_status out nocopy VARCHAR2
104: , x_msg_count out nocopy NUMBER
105: , x_msg_data out nocopy VARCHAR2
106: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
104: , x_msg_count out nocopy NUMBER
105: , x_msg_data out nocopy VARCHAR2
106: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
112: , p8_a6 out nocopy JTF_DATE_TABLE
105: , x_msg_data out nocopy VARCHAR2
106: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
112: , p8_a6 out nocopy JTF_DATE_TABLE
113: );
106: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
108: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
112: , p8_a6 out nocopy JTF_DATE_TABLE
113: );
114: end iem_knowledgebase_pub_w;