1 PACKAGE BODY IEM_PREPENQDEQ_PUB as
2 /* $Header: iemppedb.pls 115.19 2004/04/08 21:18:54 chtang shipped $*/
3
4 G_PKG_NAME varchar2(255) :='IEM_PREPENQDEQ_PUB';
5
6 PROCEDURE PREP_ENQUEUE(
7 P_Api_Version_Number IN NUMBER,
8 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_msg_id IN NUMBER,
11 p_msg_size IN NUMBER,
12 p_sender_name IN VARCHAR2,
13 p_user_name IN VARCHAR2,
14 p_domain_name IN VARCHAR2,
15 p_priority IN VARCHAR2,
16 p_msg_status IN VARCHAR2,
17 p_key1 IN VARCHAR2,
18 p_val1 IN VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_data OUT NOCOPY VARCHAR2)
22
23 IS
24
25 BEGIN
26 null;
27
28 END PREP_ENQUEUE;
29
30 PROCEDURE PREP_DEQUEUE(
31 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_msg_id OUT NOCOPY NUMBER,
35 p_msg_size OUT NOCOPY NUMBER,
36 p_sender_name OUT NOCOPY VARCHAR2,
37 p_user_name OUT NOCOPY VARCHAR2,
38 p_domain_name OUT NOCOPY VARCHAR2,
39 p_priority OUT NOCOPY VARCHAR2,
40 p_msg_status OUT NOCOPY VARCHAR2,
41 p_key1 OUT NOCOPY VARCHAR2,
42 p_val1 OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_data OUT NOCOPY VARCHAR2)
46
47 IS
48
49 BEGIN
50 null;
51 END PREP_DEQUEUE;
52
53 PROCEDURE PREP_DEQUEUE(
54 P_Api_Version_Number IN NUMBER,
55 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
56 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_qopt IN VARCHAR2,
58 p_msg_id OUT NOCOPY NUMBER,
59 p_msg_size OUT NOCOPY NUMBER,
60 p_sender_name OUT NOCOPY VARCHAR2,
61 p_user_name OUT NOCOPY VARCHAR2,
62 p_domain_name OUT NOCOPY VARCHAR2,
63 p_priority OUT NOCOPY VARCHAR2,
64 p_msg_status OUT NOCOPY VARCHAR2,
65 p_key1 OUT NOCOPY VARCHAR2,
66 p_val1 OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_data OUT NOCOPY VARCHAR2)
70
71 IS
72 BEGIN
73 null;
74 END PREP_DEQUEUE;
75
76 PROCEDURE PREP_DEQUEUE(
77 P_Api_Version_Number IN NUMBER,
78 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_qopt IN VARCHAR2,
81 p_qdeq IN VARCHAR2,
82 p_msg_id OUT NOCOPY NUMBER,
83 p_msg_size OUT NOCOPY NUMBER,
84 p_sender_name OUT NOCOPY VARCHAR2,
85 p_user_name OUT NOCOPY VARCHAR2,
86 p_domain_name OUT NOCOPY VARCHAR2,
87 p_priority OUT NOCOPY VARCHAR2,
88 p_msg_status OUT NOCOPY VARCHAR2,
89 p_key1 OUT NOCOPY VARCHAR2,
90 p_val1 OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_data OUT NOCOPY VARCHAR2)
94
95 IS
96
97 BEGIN
98 null;
99 END PREP_DEQUEUE;
100
101 PROCEDURE PROC_ENQUEUE(
102 P_Api_Version_Number IN NUMBER,
103 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
104 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_msg_id IN NUMBER,
106 p_msg_size IN NUMBER,
107 p_sender_name IN VARCHAR2,
108 p_user_name IN VARCHAR2,
109 p_domain_name IN VARCHAR2,
110 p_priority IN VARCHAR2,
111 p_msg_status IN VARCHAR2,
112 p_subject IN varchar2,
113 p_sent_date IN date,
114 p_customer_id IN number,
115 p_product_id IN number,
116 p_classification IN varchar2,
117 p_score_percent IN number,
118 p_info_id IN number,
119 p_key1 IN VARCHAR2,
120 p_val1 IN VARCHAR2,
121 p_key2 IN varchar2,
122 p_val2 IN varchar2,
123 p_key3 IN varchar2,
124 p_val3 IN varchar2,
125 p_key4 IN varchar2,
126 p_val4 IN varchar2,
127 p_key5 IN varchar2,
128 p_val5 IN varchar2,
129 p_key6 IN varchar2,
130 p_val6 IN varchar2,
131 p_key7 IN varchar2,
132 p_val7 IN varchar2,
133 p_key8 IN varchar2,
134 p_val8 IN varchar2,
135 p_key9 IN varchar2,
136 p_val9 IN varchar2,
137 p_key10 IN varchar2,
138 p_val10 IN varchar2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_data OUT NOCOPY VARCHAR2)
142
143 IS
144
145 BEGIN
146 null;
147 END PROC_ENQUEUE;
148
149 PROCEDURE PROC_DEQUEUE(
150 P_Api_Version_Number IN NUMBER,
151 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
152 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
153 p_msg_id OUT NOCOPY NUMBER,
154 p_msg_size OUT NOCOPY NUMBER,
155 p_sender_name OUT NOCOPY VARCHAR2,
156 p_user_name OUT NOCOPY VARCHAR2,
157 p_domain_name OUT NOCOPY VARCHAR2,
158 p_priority OUT NOCOPY VARCHAR2,
159 p_msg_status OUT NOCOPY VARCHAR2,
160 p_subject OUT NOCOPY VARCHAR2,
161 p_sent_date OUT NOCOPY date,
162 p_customer_id OUT NOCOPY number,
163 p_product_id OUT NOCOPY number,
164 p_classification OUT NOCOPY varchar2,
165 p_score_percent OUT NOCOPY number,
166 p_info_id OUT NOCOPY number,
167 p_key1 OUT NOCOPY varchar2,
168 p_val1 OUT NOCOPY varchar2,
169 p_key2 OUT NOCOPY varchar2,
170 p_val2 OUT NOCOPY varchar2,
171 p_key3 OUT NOCOPY varchar2,
172 p_val3 OUT NOCOPY varchar2,
173 p_key4 OUT NOCOPY varchar2,
174 p_val4 OUT NOCOPY varchar2,
175 p_key5 OUT NOCOPY varchar2,
176 p_val5 OUT NOCOPY varchar2,
177 p_key6 OUT NOCOPY varchar2,
178 p_val6 OUT NOCOPY varchar2,
179 p_key7 OUT NOCOPY varchar2,
180 p_val7 OUT NOCOPY varchar2,
181 p_key8 OUT NOCOPY varchar2,
182 p_val8 OUT NOCOPY varchar2,
183 p_key9 OUT NOCOPY varchar2,
184 p_val9 OUT NOCOPY varchar2,
185 p_key10 OUT NOCOPY varchar2,
186 p_val10 OUT NOCOPY varchar2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_data OUT NOCOPY VARCHAR2)
190 IS
191 BEGIN
192 null;
193 END PROC_DEQUEUE;
194
195 PROCEDURE PROC_DEQUEUE(
196 P_Api_Version_Number IN NUMBER,
197 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_qopt IN VARCHAR2,
200 p_msg_id OUT NOCOPY NUMBER,
201 p_msg_size OUT NOCOPY NUMBER,
202 p_sender_name OUT NOCOPY VARCHAR2,
203 p_user_name OUT NOCOPY VARCHAR2,
204 p_domain_name OUT NOCOPY VARCHAR2,
205 p_priority OUT NOCOPY VARCHAR2,
206 p_msg_status OUT NOCOPY VARCHAR2,
207 p_subject OUT NOCOPY VARCHAR2,
208 p_sent_date OUT NOCOPY date,
209 p_customer_id OUT NOCOPY number,
210 p_product_id OUT NOCOPY number,
211 p_classification OUT NOCOPY varchar2,
212 p_score_percent OUT NOCOPY number,
213 p_info_id OUT NOCOPY number,
214 p_key1 OUT NOCOPY varchar2,
215 p_val1 OUT NOCOPY varchar2,
216 p_key2 OUT NOCOPY varchar2,
217 p_val2 OUT NOCOPY varchar2,
218 p_key3 OUT NOCOPY varchar2,
219 p_val3 OUT NOCOPY varchar2,
220 p_key4 OUT NOCOPY varchar2,
221 p_val4 OUT NOCOPY varchar2,
222 p_key5 OUT NOCOPY varchar2,
223 p_val5 OUT NOCOPY varchar2,
224 p_key6 OUT NOCOPY varchar2,
225 p_val6 OUT NOCOPY varchar2,
226 p_key7 OUT NOCOPY varchar2,
227 p_val7 OUT NOCOPY varchar2,
228 p_key8 OUT NOCOPY varchar2,
229 p_val8 OUT NOCOPY varchar2,
230 p_key9 OUT NOCOPY varchar2,
231 p_val9 OUT NOCOPY varchar2,
232 p_key10 OUT NOCOPY varchar2,
233 p_val10 OUT NOCOPY varchar2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_data OUT NOCOPY VARCHAR2)
237 IS
238 BEGIN
239 null;
240 END PROC_DEQUEUE;
241
242 PROCEDURE PROC_DEQUEUE(
243 P_Api_Version_Number IN NUMBER,
244 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
245 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
246 p_qopt IN VARCHAR2,
247 p_qdeq IN VARCHAR2,
248 p_msg_id OUT NOCOPY NUMBER,
249 p_msg_size OUT NOCOPY NUMBER,
250 p_sender_name OUT NOCOPY VARCHAR2,
251 p_user_name OUT NOCOPY VARCHAR2,
252 p_domain_name OUT NOCOPY VARCHAR2,
253 p_priority OUT NOCOPY VARCHAR2,
254 p_msg_status OUT NOCOPY VARCHAR2,
255 p_subject OUT NOCOPY VARCHAR2,
256 p_sent_date OUT NOCOPY date,
257 p_customer_id OUT NOCOPY number,
258 p_product_id OUT NOCOPY number,
259 p_classification OUT NOCOPY varchar2,
260 p_score_percent OUT NOCOPY number,
261 p_info_id OUT NOCOPY number,
262 p_key1 OUT NOCOPY varchar2,
263 p_val1 OUT NOCOPY varchar2,
264 p_key2 OUT NOCOPY varchar2,
265 p_val2 OUT NOCOPY varchar2,
266 p_key3 OUT NOCOPY varchar2,
267 p_val3 OUT NOCOPY varchar2,
268 p_key4 OUT NOCOPY varchar2,
269 p_val4 OUT NOCOPY varchar2,
270 p_key5 OUT NOCOPY varchar2,
271 p_val5 OUT NOCOPY varchar2,
272 p_key6 OUT NOCOPY varchar2,
273 p_val6 OUT NOCOPY varchar2,
274 p_key7 OUT NOCOPY varchar2,
275 p_val7 OUT NOCOPY varchar2,
276 p_key8 OUT NOCOPY varchar2,
277 p_val8 OUT NOCOPY varchar2,
278 p_key9 OUT NOCOPY varchar2,
279 p_val9 OUT NOCOPY varchar2,
280 p_key10 OUT NOCOPY varchar2,
281 p_val10 OUT NOCOPY varchar2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_data OUT NOCOPY VARCHAR2)
285 IS
286
287 BEGIN
288 null;
289 END PROC_DEQUEUE;
290
291 PROCEDURE ENABLE_QUEUE(
292 P_Api_Version_Number IN NUMBER,
293 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
294 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
295 p_queue_name IN VARCHAR2,
296 p_enqueue IN VARCHAR2,
297 p_dequeue IN VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_data OUT NOCOPY VARCHAR2)
301
302 IS
303
304 BEGIN
305 null;
306
307 END ENABLE_QUEUE;
308
309 PROCEDURE DISABLE_QUEUE(
310 P_Api_Version_Number IN NUMBER,
311 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
312 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
313 p_queue_name IN VARCHAR2,
314 p_enqueue IN VARCHAR2,
315 p_dequeue IN VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_data OUT NOCOPY VARCHAR2)
319
320 IS
321
322 BEGIN
323 null;
324 END DISABLE_QUEUE;
325
326 End IEM_PREPENQDEQ_PUB;