[Home] [Help]
PACKAGE: APPS.IEM_KNOWLEDGEBASE_PUB_W
Source
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
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 );
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 );
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 );
32
33 procedure get_suggresponse(p_api_version_number NUMBER
34 , p_init_msg_list VARCHAR2
35 , p_commit VARCHAR2
36 , p_email_account_id NUMBER
37 , p_message_id VARCHAR2
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
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
51 , p_init_msg_list VARCHAR2
52 , p_commit VARCHAR2
53 , p_email_account_id 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
63 );
64 procedure get_kb_suggresponse(p_api_version_number NUMBER
65 , p_init_msg_list VARCHAR2
66 , p_commit VARCHAR2
67 , p_email_account_id NUMBER
68 , p_message_id VARCHAR2
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
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
82 , p_init_msg_list VARCHAR2
83 , p_commit VARCHAR2
84 , p_email_account_id NUMBER
85 , p_message_id VARCHAR2
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
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
99 , p_init_msg_list VARCHAR2
100 , p_commit VARCHAR2
101 , p_email_account_id 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
111 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_300
112 , p8_a6 out nocopy JTF_DATE_TABLE
113 );
114 end iem_knowledgebase_pub_w;