1 PACKAGE IEM_THEMES_PVT AUTHID CURRENT_USER as
2 /* $Header: iempthes.pls 115.10 2003/08/26 23:41:53 sboorela shipped $*/
3 /*****************************************************************/
4 -- Start of Comments
5 -- API name : create_item
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_THEMES
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_score IN NUMBER,
15 -- p_classification_id IN NUMBER,
16 -- p_theme IN VARCHAR2,
17 -- p_query_response IN VARCHAR2,
18 -- p_account_name IN VARCHAR2,
19 --
20 -- OUT
21 -- x_return_status OUT VARCHAR2
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2
24 --
25 -- Version : 1.0
26 -- Notes :
27 --
28 -- End of comments
29 -- **********************************************************
30
31 PROCEDURE create_item (p_api_version_number IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_score IN NUMBER,
35 p_classification_id IN NUMBER,
36 p_theme IN VARCHAR2,
37 p_query_response IN VARCHAR2,
38 p_CREATED_BY IN NUMBER,
39 p_CREATION_DATE IN DATE,
40 p_LAST_UPDATED_BY IN NUMBER ,
41 p_LAST_UPDATE_DATE IN DATE,
42 p_LAST_UPDATE_LOGIN IN NUMBER ,
43 p_ATTRIBUTE1 IN VARCHAR2,
44 p_ATTRIBUTE2 IN VARCHAR2,
45 p_ATTRIBUTE3 IN VARCHAR2,
46 p_ATTRIBUTE4 IN VARCHAR2,
47 p_ATTRIBUTE5 IN VARCHAR2,
48 p_ATTRIBUTE6 IN VARCHAR2,
49 p_ATTRIBUTE7 IN VARCHAR2,
50 p_ATTRIBUTE8 IN VARCHAR2,
51 p_ATTRIBUTE9 IN VARCHAR2,
52 p_ATTRIBUTE10 IN VARCHAR2,
53 p_ATTRIBUTE11 IN VARCHAR2,
54 p_ATTRIBUTE12 IN VARCHAR2,
55 p_ATTRIBUTE13 IN VARCHAR2,
56 p_ATTRIBUTE14 IN VARCHAR2,
57 p_ATTRIBUTE15 IN VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2
61 );
62
63 -- Start of Comments
64 -- API name : delete_item
65 -- Type : Private
66 -- Function : This procedure deletes a record in the table IEM_THEMES
67 -- Pre-reqs : None.
68 -- Parameters :
69 -- IN
70 -- p_api_version_number IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
72 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
73 -- p_theme_id IN VARCHAR2,
74 --
75 -- OUT
76 -- x_return_status OUT VARCHAR2
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2
79 --
80 -- Version : 1.0
81 -- Notes :
82 --
83 -- End of comments
84 -- **********************************************************
85
86 PROCEDURE delete_item (p_api_version_number IN NUMBER,
87 p_init_msg_list IN VARCHAR2 ,
88 p_commit IN VARCHAR2 ,
89 p_theme_id IN NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 -- Start of Comments
96 -- API name : update_item
97 -- Type : Private
98 -- Function : This procedure updates a record in the table IEM_THEMES
99 -- Pre-reqs : None.
100 -- Parameters :
101 -- IN
102 -- p_api_version_number IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105 -- p_theme_id IN VARCHAR2,
106 --
107 -- OUT
108 -- x_return_status OUT VARCHAR2
109 -- x_msg_count OUT NUMBER
110 -- x_msg_data OUT VARCHAR2
111 --
112 -- Version : 1.0
113 -- Notes :
114 --
115 -- End of comments
116 -- **********************************************************
117 PROCEDURE update_item (p_api_version_number IN NUMBER,
118 p_init_msg_list IN VARCHAR2 ,
119 p_commit IN VARCHAR2 ,
120 p_theme_id IN NUMBER,
121 p_classification_id IN NUMBER,
122 p_theme IN VARCHAR2 ,
123 p_score IN NUMBER,
124 p_query_response IN VARCHAR2,
125 p_LAST_UPDATED_BY IN NUMBER ,
126 p_LAST_UPDATE_DATE IN DATE,
127 p_LAST_UPDATE_LOGIN IN NUMBER ,
128 p_ATTRIBUTE1 IN VARCHAR2,
129 p_ATTRIBUTE2 IN VARCHAR2,
130 p_ATTRIBUTE3 IN VARCHAR2,
131 p_ATTRIBUTE4 IN VARCHAR2,
132 p_ATTRIBUTE5 IN VARCHAR2,
133 p_ATTRIBUTE6 IN VARCHAR2,
134 p_ATTRIBUTE7 IN VARCHAR2,
135 p_ATTRIBUTE8 IN VARCHAR2,
136 p_ATTRIBUTE9 IN VARCHAR2,
137 p_ATTRIBUTE10 IN VARCHAR2,
138 p_ATTRIBUTE11 IN VARCHAR2,
139 p_ATTRIBUTE12 IN VARCHAR2,
140 p_ATTRIBUTE13 IN VARCHAR2,
141 p_ATTRIBUTE14 IN VARCHAR2,
142 p_ATTRIBUTE15 IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148
149 PROCEDURE create_item_wrap (p_api_version_number IN NUMBER,
150 p_init_msg_list IN VARCHAR2 ,
151 p_commit IN VARCHAR2 ,
152 p_score IN NUMBER,
153 p_classification_id IN NUMBER,
154 p_theme IN VARCHAR2,
155 p_query_response IN VARCHAR2,
156 p_CREATED_BY NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE create_item_wrap_sss (p_api_version_number IN NUMBER,
163 p_init_msg_list IN VARCHAR2 ,
164 p_commit IN VARCHAR2 ,
165 p_score IN NUMBER,
166 p_classification_id IN NUMBER,
167 p_theme IN VARCHAR2,
168 p_query_response IN VARCHAR2,
169 p_CREATED_BY NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 PROCEDURE delete_item_wrap
176 (p_api_version_number IN NUMBER,
177 P_init_msg_list IN VARCHAR2 ,
178 p_commit IN VARCHAR2 ,
179 p_thes_ids_tbl IN jtf_varchar2_Table_100,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2);
183
184 PROCEDURE delete_item_wrap_sss
185 (p_api_version_number IN NUMBER,
186 P_init_msg_list IN VARCHAR2 ,
187 p_commit IN VARCHAR2 ,
188 p_thes_ids_tbl IN jtf_varchar2_Table_100,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2);
192
193 PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,
194 p_init_msg_list IN VARCHAR2 ,
195 p_commit IN VARCHAR2 ,
196 p_theme_id IN NUMBER,
197 p_classification_id IN NUMBER,
198 p_theme IN VARCHAR2 ,
199 p_score IN NUMBER,
200 p_query_response IN VARCHAR2,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2
204 );
205
206 /****************************************************************/
207 -- this API is called by Postman rule processing for inserting
208 -- records into IEM_THEMES
209 PROCEDURE create_item_pm (p_score IN NUMBER,
210 p_classification_id IN NUMBER,
211 p_theme IN VARCHAR2,
212 p_query_response IN VARCHAR2,
213 p_doc_seq_no IN NUMBER,
214 p_CREATED_BY NUMBER,
215 p_CREATION_DATE DATE,
216 p_LAST_UPDATED_BY NUMBER,
217 p_LAST_UPDATE_DATE DATE,
218 p_LAST_UPDATE_LOGIN NUMBER,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2
222 );
223 PROCEDURE calculate_weight (p_email_account_id IN NUMBER,
224 p_query_response IN VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2
226 );
227 END IEM_THEMES_PVT;