1 PACKAGE IEM_PREPENQDEQ_PUB AUTHID CURRENT_USER as
2 /* $Header: iemppeds.pls 115.11 2002/12/04 20:23:20 sboorela shipped $*/
3 -- Start of Comments
4 -- API name : 'PREP_ENQUEUE`
5 -- Purpose : Enqueues a message into pre-processing AQ
6 -- Pre-reqs : None
7 -- Parameters :
8 -- IN
9 -- p_api_version_number IN NUMBER Required
10 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
11 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
12 -- p_msg_id IN NUMBER Required
13 -- p_msg_size IN NUMBER Required
14 -- p_sender_name IN VARCHAR2 Required
15 -- p_user_name IN VARCHAR2 Required
16 -- p_domain_name IN VARCHAR2 Required
17 -- p_priority IN VARCHAR2 Optional
18 -- p_msg_status IN VARCHAR2 Optional
19 -- p_key1 IN VARCHAR2 Optional
20 -- p_val1 IN VARCHAR2 Optional
21 --
22 -- OUT:
23 -- x_return_status OUT VARCHAR2
24 -- x_msg_count OUT NUMBER
25 -- x_msg_data OUT VARCHAR2
26 --
27 -- Version : Current version 1.0
28 -- Note:
29 --
30 -- End of Comments
31
32
33 PROCEDURE PREP_ENQUEUE(
34 P_Api_Version_Number IN NUMBER,
35 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
36 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
37 p_msg_id IN NUMBER,
38 p_msg_size IN NUMBER,
39 p_sender_name IN VARCHAR2,
40 p_user_name IN VARCHAR2,
41 p_domain_name IN VARCHAR2,
42 p_priority IN VARCHAR2,
43 p_msg_status IN VARCHAR2,
44 p_key1 IN VARCHAR2,
45 p_val1 IN VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_data OUT NOCOPY VARCHAR2);
49
50
51 -- Start of Comments
52 -- API name : 'PREP_DEQUEUE`
53 -- Purpose : Dequeues a message from pre-processing AQ
54 -- Pre-reqs : None
55 -- Parameters :
56 -- IN
57 -- p_api_version_number IN NUMBER Required
58 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
59 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
60 -- p_msg_id OUT NUMBER
61 -- p_msg_size OUT NUMBER
62 -- p_sender_name OUT VARCHAR2
63 -- p_user_name OUT VARCHAR2
64 -- p_domain_name OUT VARCHAR2
65 -- p_priority OUT VARCHAR2
66 -- p_msg_status OUT VARCHAR2
67 -- p_key1 OUT VARCHAR2
68 -- p_val1 OUT VARCHAR2
69 --
70 -- OUT:
71 -- x_return_status OUT VARCHAR2
72 -- x_msg_count OUT NUMBER
73 -- x_msg_data OUT VARCHAR2
74 --
75 -- Version : Current version 1.0
76 -- Note:
77 --
78 -- End of Comments
79
80
81 PROCEDURE PREP_DEQUEUE(
82 P_Api_Version_Number IN NUMBER,
83 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
84 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_msg_id OUT NOCOPY NUMBER,
86 p_msg_size OUT NOCOPY NUMBER,
87 p_sender_name OUT NOCOPY VARCHAR2,
88 p_user_name OUT NOCOPY VARCHAR2,
89 p_domain_name OUT NOCOPY VARCHAR2,
90 p_priority OUT NOCOPY VARCHAR2,
91 p_msg_status OUT NOCOPY VARCHAR2,
92 p_key1 OUT NOCOPY VARCHAR2,
93 p_val1 OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_data OUT NOCOPY VARCHAR2);
97
98
99 -- Start of Comments
100 -- API name : 'PREP_DEQUEUE`
101 -- Purpose : Dequeues a message from pre-processing AQ
102 -- Pre-reqs : None
103 -- Parameters :
104 -- IN
105 -- p_api_version_number IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
107 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
108 -- p_qopt IN VARCHAR2
109 -- p_msg_id OUT NUMBER
110 -- p_msg_size OUT NUMBER
111 -- p_sender_name OUT VARCHAR2
112 -- p_user_name OUT VARCHAR2
113 -- p_domain_name OUT VARCHAR2
114 -- p_priority OUT VARCHAR2
115 -- p_msg_status OUT VARCHAR2
116 -- p_key1 OUT VARCHAR2
117 -- p_val1 OUT VARCHAR2
118 --
119 -- OUT:
120 -- x_return_status OUT VARCHAR2
121 -- x_msg_count OUT NUMBER
122 -- x_msg_data OUT VARCHAR2
123 --
124 -- Version : Current version 1.0
125 -- Note:
126 --
127 -- End of Comments
128
129
130 PROCEDURE PREP_DEQUEUE(
131 P_Api_Version_Number IN NUMBER,
132 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_qopt IN VARCHAR2,
135 p_msg_id OUT NOCOPY NUMBER,
136 p_msg_size OUT NOCOPY NUMBER,
137 p_sender_name OUT NOCOPY VARCHAR2,
138 p_user_name OUT NOCOPY VARCHAR2,
139 p_domain_name OUT NOCOPY VARCHAR2,
140 p_priority OUT NOCOPY VARCHAR2,
141 p_msg_status OUT NOCOPY VARCHAR2,
142 p_key1 OUT NOCOPY VARCHAR2,
143 p_val1 OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_data OUT NOCOPY VARCHAR2);
147
148
149 -- Start of Comments
150 -- API name : 'PREP_DEQUEUE`
151 -- Purpose : Dequeues a message from pre-processing AQ
152 -- Pre-reqs : None
153 -- Parameters :
154 -- IN
155 -- p_api_version_number IN NUMBER Required
156 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
157 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
158 -- p_qopt IN VARCHAR2
159 -- p_qdeq IN VARCHAR2
160 -- p_msg_id OUT NUMBER
161 -- p_msg_size OUT NUMBER
162 -- p_sender_name OUT VARCHAR2
163 -- p_user_name OUT VARCHAR2
164 -- p_domain_name OUT VARCHAR2
165 -- p_priority OUT VARCHAR2
166 -- p_msg_status OUT VARCHAR2
167 -- p_key1 OUT VARCHAR2
168 -- p_val1 OUT VARCHAR2
169 --
170 -- OUT:
171 -- x_return_status OUT VARCHAR2
172 -- x_msg_count OUT NUMBER
173 -- x_msg_data OUT VARCHAR2
174 --
175 -- Version : Current version 1.0
176 -- Note:
177 --
178 -- End of Comments
179
180
181 PROCEDURE PREP_DEQUEUE(
182 P_Api_Version_Number IN NUMBER,
183 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
184 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_qopt IN VARCHAR2,
186 p_qdeq IN VARCHAR2,
187 p_msg_id OUT NOCOPY NUMBER,
188 p_msg_size OUT NOCOPY NUMBER,
189 p_sender_name OUT NOCOPY VARCHAR2,
190 p_user_name OUT NOCOPY VARCHAR2,
191 p_domain_name OUT NOCOPY VARCHAR2,
192 p_priority OUT NOCOPY VARCHAR2,
193 p_msg_status OUT NOCOPY VARCHAR2,
194 p_key1 OUT NOCOPY VARCHAR2,
195 p_val1 OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_data OUT NOCOPY VARCHAR2);
199
200
201 -- Start of Comments
202 -- API name : 'PROC_ENQUEUE`
203 -- Purpose : Enqueues a message into processing AQ
204 -- Pre-reqs : None
205 -- Parameters :
206 -- IN
207 -- p_api_version_number IN NUMBER Required
208 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210 -- p_msg_id IN NUMBER
211 -- p_msg_size IN NUMBER
212 -- p_sender_name IN VARCHAR2
213 -- p_user_name IN VARCHAR2
214 -- p_domain_name IN VARCHAR2
215 -- p_priority IN VARCHAR2
216 -- p_msg_status IN VARCHAR2
217 -- p_subject IN VARCHAR2
218 -- p_sent_date IN DATE
219 -- p_customer_id IN NUMBER
220 -- p_product_id IN NUMBER
221 -- p_classification IN VARCHAR2
222 -- p_score_percent IN NUMBER
223 -- p_info_id IN NUMBER
224 -- p_key1 IN VARCHAR2
225 -- p_val1 IN VARCHAR2
226 -- p_key2 IN VARCHAR2
227 -- p_val2 IN VARCHAR2
228 -- p_key3 IN VARCHAR2
229 -- p_val3 IN VARCHAR2
230 -- p_key4 IN VARCHAR2
231 -- p_val4 IN VARCHAR2
232 -- p_key5 IN VARCHAR2
233 -- p_val5 IN VARCHAR2
234 -- p_key6 IN VARCHAR2
235 -- p_val6 IN VARCHAR2
236 -- p_key7 IN VARCHAR2
237 -- p_val7 IN VARCHAR2
238 -- p_key8 IN VARCHAR2
239 -- p_val8 IN VARCHAR2
240 -- p_key9 IN VARCHAR2
241 -- p_val9 IN VARCHAR2
242 -- p_key10 IN VARCHAR2
243 -- p_val10 IN VARCHAR2
244 -- OUT:
245 -- x_return_status OUT VARCHAR2
246 -- x_msg_count OUT NUMBER
247 -- x_msg_data OUT VARCHAR2
248 --
249 -- Version : Current version 1.0
250 -- Note:
251 --
252 -- End of Comments
253
254 PROCEDURE PROC_ENQUEUE(
255 P_Api_Version_Number IN NUMBER,
256 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
258 p_msg_id IN NUMBER,
259 p_msg_size IN NUMBER,
260 p_sender_name IN VARCHAR2,
261 p_user_name IN VARCHAR2,
262 p_domain_name IN VARCHAR2,
263 p_priority IN VARCHAR2,
264 p_msg_status IN VARCHAR2,
265 p_subject IN VARCHAR2,
266 p_sent_date IN date,
267 p_customer_id IN number,
268 p_product_id IN number,
269 p_classification IN varchar2,
270 p_score_percent IN number,
271 p_info_id IN number,
272 p_key1 IN varchar2,
273 p_val1 IN varchar2,
274 p_key2 IN varchar2,
275 p_val2 IN varchar2,
276 p_key3 IN varchar2,
277 p_val3 IN varchar2,
278 p_key4 IN varchar2,
279 p_val4 IN varchar2,
280 p_key5 IN varchar2,
281 p_val5 IN varchar2,
282 p_key6 IN varchar2,
283 p_val6 IN varchar2,
284 p_key7 IN varchar2,
285 p_val7 IN varchar2,
286 p_key8 IN varchar2,
287 p_val8 IN varchar2,
288 p_key9 IN varchar2,
289 p_val9 IN varchar2,
290 p_key10 IN varchar2,
291 p_val10 IN varchar2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_data OUT NOCOPY VARCHAR2);
295
296 -- Start of Comments
297 -- API name : 'PROC_DEQUEUE`
298 -- Purpose : Dequeues a message from processing AQ
299 -- Pre-reqs : None
300 -- Parameters :
301 -- IN
302 -- p_api_version_number IN NUMBER Required
303 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
304 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
305 -- p_msg_id OUT NUMBER
306 -- p_msg_size OUT NUMBER
307 -- p_sender_name OUT VARCHAR2
308 -- p_user_name OUT VARCHAR2
309 -- p_domain_name OUT VARCHAR2
310 -- p_priority OUT VARCHAR2
311 -- p_msg_status OUT VARCHAR2
312 -- p_subject OUT VARCHAR2
313 -- p_sent_date OUT DATE
314 -- p_customer_id OUT NUMBER
315 -- p_product_id OUT NUMBER
316 -- p_classification OUT VARCHAR2
317 -- p_score_percent OUT NUMBER
318 -- p_info_id OUT NUMBER
319 -- p_key1 OUT VARCHAR2
320 -- p_val1 OUT VARCHAR2
321 -- p_key2 OUT VARCHAR2
322 -- p_val2 OUT VARCHAR2
323 -- p_key3 OUT VARCHAR2
324 -- p_val3 OUT VARCHAR2
325 -- p_key4 OUT VARCHAR2
326 -- p_val4 OUT VARCHAR2
327 -- p_key5 OUT VARCHAR2
328 -- p_val5 OUT VARCHAR2
329 -- p_key6 OUT VARCHAR2
330 -- p_val6 OUT VARCHAR2
331 -- p_key7 OUT VARCHAR2
332 -- p_val7 OUT VARCHAR2
333 -- p_key8 OUT VARCHAR2
334 -- p_val8 OUT VARCHAR2
335 -- p_key9 OUT VARCHAR2
336 -- p_val9 OUT VARCHAR2
337 -- p_key10 OUT VARCHAR2
338 -- p_val10 OUT VARCHAR2
339 -- OUT:
340 -- x_return_status OUT VARCHAR2
341 -- x_msg_count OUT NUMBER
342 -- x_msg_data OUT VARCHAR2
343 --
344 -- Version : Current version 1.0
345 -- Note:
346 --
347 -- End of Comments
348
349 PROCEDURE PROC_DEQUEUE(
350 P_Api_Version_Number IN NUMBER,
351 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
352 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
353 p_msg_id OUT NOCOPY NUMBER,
354 p_msg_size OUT NOCOPY NUMBER,
355 p_sender_name OUT NOCOPY VARCHAR2,
356 p_user_name OUT NOCOPY VARCHAR2,
357 p_domain_name OUT NOCOPY VARCHAR2,
358 p_priority OUT NOCOPY VARCHAR2,
359 p_msg_status OUT NOCOPY VARCHAR2,
360 p_subject OUT NOCOPY VARCHAR2,
361 p_sent_date OUT NOCOPY date,
362 p_customer_id OUT NOCOPY number,
363 p_product_id OUT NOCOPY number,
364 p_classification OUT NOCOPY varchar2,
365 p_score_percent OUT NOCOPY number,
366 p_info_id OUT NOCOPY number,
367 p_key1 OUT NOCOPY varchar2,
368 p_val1 OUT NOCOPY varchar2,
369 p_key2 OUT NOCOPY varchar2,
370 p_val2 OUT NOCOPY varchar2,
371 p_key3 OUT NOCOPY varchar2,
372 p_val3 OUT NOCOPY varchar2,
373 p_key4 OUT NOCOPY varchar2,
374 p_val4 OUT NOCOPY varchar2,
375 p_key5 OUT NOCOPY varchar2,
376 p_val5 OUT NOCOPY varchar2,
377 p_key6 OUT NOCOPY varchar2,
378 p_val6 OUT NOCOPY varchar2,
379 p_key7 OUT NOCOPY varchar2,
380 p_val7 OUT NOCOPY varchar2,
381 p_key8 OUT NOCOPY varchar2,
382 p_val8 OUT NOCOPY varchar2,
383 p_key9 OUT NOCOPY varchar2,
384 p_val9 OUT NOCOPY varchar2,
385 p_key10 OUT NOCOPY varchar2,
386 p_val10 OUT NOCOPY varchar2,
387 x_msg_count OUT NOCOPY NUMBER,
388 x_return_status OUT NOCOPY VARCHAR2,
389 x_msg_data OUT NOCOPY VARCHAR2);
390
391 -- Start of Comments
392 -- API name : 'PROC_DEQUEUE`
393 -- Purpose : Dequeues a message from processing AQ
394 -- Pre-reqs : None
395 -- Parameters :
396 -- IN
397 -- p_api_version_number IN NUMBER Required
398 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
399 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
400 -- p_qopt IN VARCHAR2
401 -- p_msg_id OUT NUMBER
402 -- p_msg_size OUT NUMBER
403 -- p_sender_name OUT VARCHAR2
404 -- p_user_name OUT VARCHAR2
405 -- p_domain_name OUT VARCHAR2
406 -- p_priority OUT VARCHAR2
407 -- p_msg_status OUT VARCHAR2
408 -- p_subject OUT VARCHAR2
409 -- p_sent_date OUT DATE
410 -- p_customer_id OUT NUMBER
411 -- p_product_id OUT NUMBER
412 -- p_classification OUT VARCHAR2
413 -- p_score_percent OUT NUMBER
414 -- p_info_id OUT NUMBER
415 -- p_key1 OUT VARCHAR2
416 -- p_val1 OUT VARCHAR2
417 -- p_key2 OUT VARCHAR2
418 -- p_val2 OUT VARCHAR2
419 -- p_key3 OUT VARCHAR2
420 -- p_val3 OUT VARCHAR2
421 -- p_key4 OUT VARCHAR2
422 -- p_val4 OUT VARCHAR2
423 -- p_key5 OUT VARCHAR2
424 -- p_val5 OUT VARCHAR2
425 -- p_key6 OUT VARCHAR2
429 -- p_key8 OUT VARCHAR2
426 -- p_val6 OUT VARCHAR2
427 -- p_key7 OUT VARCHAR2
428 -- p_val7 OUT VARCHAR2
430 -- p_val8 OUT VARCHAR2
431 -- p_key9 OUT VARCHAR2
432 -- p_val9 OUT VARCHAR2
433 -- p_key10 OUT VARCHAR2
434 -- p_val10 OUT VARCHAR2
435 -- OUT:
436 -- x_return_status OUT VARCHAR2
437 -- x_msg_count OUT NUMBER
438 -- x_msg_data OUT VARCHAR2
439 --
440 -- Version : Current version 1.0
441 -- Note:
442 --
443 -- End of Comments
444
445 PROCEDURE PROC_DEQUEUE(
446 P_Api_Version_Number IN NUMBER,
447 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
448 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
449 p_qopt IN VARCHAR2,
450 p_msg_id OUT NOCOPY NUMBER,
451 p_msg_size OUT NOCOPY NUMBER,
452 p_sender_name OUT NOCOPY VARCHAR2,
453 p_user_name OUT NOCOPY VARCHAR2,
454 p_domain_name OUT NOCOPY VARCHAR2,
455 p_priority OUT NOCOPY VARCHAR2,
456 p_msg_status OUT NOCOPY VARCHAR2,
457 p_subject OUT NOCOPY VARCHAR2,
458 p_sent_date OUT NOCOPY date,
459 p_customer_id OUT NOCOPY number,
460 p_product_id OUT NOCOPY number,
461 p_classification OUT NOCOPY varchar2,
462 p_score_percent OUT NOCOPY number,
463 p_info_id OUT NOCOPY number,
464 p_key1 OUT NOCOPY varchar2,
465 p_val1 OUT NOCOPY varchar2,
466 p_key2 OUT NOCOPY varchar2,
467 p_val2 OUT NOCOPY varchar2,
468 p_key3 OUT NOCOPY varchar2,
469 p_val3 OUT NOCOPY varchar2,
470 p_key4 OUT NOCOPY varchar2,
471 p_val4 OUT NOCOPY varchar2,
472 p_key5 OUT NOCOPY varchar2,
473 p_val5 OUT NOCOPY varchar2,
474 p_key6 OUT NOCOPY varchar2,
475 p_val6 OUT NOCOPY varchar2,
476 p_key7 OUT NOCOPY varchar2,
477 p_val7 OUT NOCOPY varchar2,
478 p_key8 OUT NOCOPY varchar2,
479 p_val8 OUT NOCOPY varchar2,
480 p_key9 OUT NOCOPY varchar2,
481 p_val9 OUT NOCOPY varchar2,
482 p_key10 OUT NOCOPY varchar2,
483 p_val10 OUT NOCOPY varchar2,
484 x_msg_count OUT NOCOPY NUMBER,
485 x_return_status OUT NOCOPY VARCHAR2,
486 x_msg_data OUT NOCOPY VARCHAR2);
487
488 -- Start of Comments
489 -- API name : 'PROC_DEQUEUE`
490 -- Purpose : Dequeues a message from processing AQ
491 -- Pre-reqs : None
492 -- Parameters :
493 -- IN
494 -- p_api_version_number IN NUMBER Required
495 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
496 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
497 -- p_qopt IN VARCHAR2
498 -- p_qdeq IN VARCHAR2
499 -- p_msg_id OUT NUMBER
500 -- p_msg_size OUT NUMBER
501 -- p_sender_name OUT VARCHAR2
502 -- p_user_name OUT VARCHAR2
503 -- p_domain_name OUT VARCHAR2
504 -- p_priority OUT VARCHAR2
505 -- p_msg_status OUT VARCHAR2
506 -- p_subject OUT VARCHAR2
507 -- p_sent_date OUT DATE
508 -- p_customer_id OUT NUMBER
509 -- p_product_id OUT NUMBER
510 -- p_classification OUT VARCHAR2
511 -- p_score_percent OUT NUMBER
512 -- p_info_id OUT NUMBER
513 -- p_key1 OUT VARCHAR2
514 -- p_val1 OUT VARCHAR2
515 -- p_key2 OUT VARCHAR2
516 -- p_val2 OUT VARCHAR2
517 -- p_key3 OUT VARCHAR2
518 -- p_val3 OUT VARCHAR2
519 -- p_key4 OUT VARCHAR2
520 -- p_val4 OUT VARCHAR2
521 -- p_key5 OUT VARCHAR2
522 -- p_val5 OUT VARCHAR2
523 -- p_key6 OUT VARCHAR2
524 -- p_val6 OUT VARCHAR2
525 -- p_key7 OUT VARCHAR2
526 -- p_val7 OUT VARCHAR2
527 -- p_key8 OUT VARCHAR2
528 -- p_val8 OUT VARCHAR2
529 -- p_key9 OUT VARCHAR2
530 -- p_val9 OUT VARCHAR2
531 -- p_key10 OUT VARCHAR2
532 -- p_val10 OUT VARCHAR2
533 -- OUT:
534 -- x_return_status OUT VARCHAR2
535 -- x_msg_count OUT NUMBER
536 -- x_msg_data OUT VARCHAR2
537 --
538 -- Version : Current version 1.0
539 -- Note:
540 --
541 -- End of Comments
542
543 PROCEDURE PROC_DEQUEUE(
544 P_Api_Version_Number IN NUMBER,
545 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
546 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
547 p_qopt IN VARCHAR2,
548 p_qdeq IN VARCHAR2,
549 p_msg_id OUT NOCOPY NUMBER,
550 p_msg_size OUT NOCOPY NUMBER,
551 p_sender_name OUT NOCOPY VARCHAR2,
552 p_user_name OUT NOCOPY VARCHAR2,
553 p_domain_name OUT NOCOPY VARCHAR2,
554 p_priority OUT NOCOPY VARCHAR2,
555 p_msg_status OUT NOCOPY VARCHAR2,
556 p_subject OUT NOCOPY VARCHAR2,
557 p_sent_date OUT NOCOPY date,
558 p_customer_id OUT NOCOPY number,
559 p_product_id OUT NOCOPY number,
560 p_classification OUT NOCOPY varchar2,
561 p_score_percent OUT NOCOPY number,
562 p_info_id OUT NOCOPY number,
563 p_key1 OUT NOCOPY varchar2,
567 p_key3 OUT NOCOPY varchar2,
564 p_val1 OUT NOCOPY varchar2,
565 p_key2 OUT NOCOPY varchar2,
566 p_val2 OUT NOCOPY varchar2,
568 p_val3 OUT NOCOPY varchar2,
569 p_key4 OUT NOCOPY varchar2,
570 p_val4 OUT NOCOPY varchar2,
571 p_key5 OUT NOCOPY varchar2,
572 p_val5 OUT NOCOPY varchar2,
573 p_key6 OUT NOCOPY varchar2,
574 p_val6 OUT NOCOPY varchar2,
575 p_key7 OUT NOCOPY varchar2,
576 p_val7 OUT NOCOPY varchar2,
577 p_key8 OUT NOCOPY varchar2,
578 p_val8 OUT NOCOPY varchar2,
579 p_key9 OUT NOCOPY varchar2,
580 p_val9 OUT NOCOPY varchar2,
581 p_key10 OUT NOCOPY varchar2,
582 p_val10 OUT NOCOPY varchar2,
583 x_msg_count OUT NOCOPY NUMBER,
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_data OUT NOCOPY VARCHAR2);
586
587 -- Start of Comments
588 -- API name : 'ENABLE_QUEUE`
589 -- Purpose : Enables a given IEM Queue
590 -- Pre-reqs : None
591 -- Parameters :
592 -- IN
593 -- p_api_version_number IN NUMBER Required
594 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
595 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
596 -- p_queue_name IN VARCHAR2
597 -- p_enqueue IN VARCHAR2
598 -- p_dequeue IN VARCHAR2
599 --
600 -- OUT:
601 -- x_return_status OUT VARCHAR2
602 -- x_msg_count OUT NUMBER
603 -- x_msg_data OUT VARCHAR2
604 --
605 -- Version : Current version 1.0
606 -- Note:
607 --
608 -- End of Comments
609
610
611 PROCEDURE ENABLE_QUEUE(
612 P_Api_Version_Number IN NUMBER,
613 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
614 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
615 p_queue_name IN VARCHAR2,
616 p_enqueue IN VARCHAR2,
617 p_dequeue IN VARCHAR2,
618 x_msg_count OUT NOCOPY NUMBER,
619 x_return_status OUT NOCOPY VARCHAR2,
620 x_msg_data OUT NOCOPY VARCHAR2);
621
622 -- Start of Comments
623 -- API name : 'DISABLE_QUEUE`
624 -- Purpose : Disables a given IEM Queue
625 -- Pre-reqs : None
626 -- Parameters :
627 -- IN
628 -- p_api_version_number IN NUMBER Required
629 -- p_init_msg_list IN VARCHAR2 Optional Default =FND_API_G_FALSE
630 -- p_commit IN VARCHAR2 Optional Default =FND_API.G_FALSE
631 -- p_queue_name IN VARCHAR2
632 -- p_enqueue IN VARCHAR2
633 -- p_dequeue IN VARCHAR2
634 --
635 -- OUT:
636 -- x_return_status OUT VARCHAR2
637 -- x_msg_count OUT NUMBER
638 -- x_msg_data OUT VARCHAR2
639 --
640 -- Version : Current version 1.0
641 -- Note:
642 --
643 -- End of Comments
644
645
646 PROCEDURE DISABLE_QUEUE(
647 P_Api_Version_Number IN NUMBER,
648 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
649 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
650 p_queue_name IN VARCHAR2,
651 p_enqueue IN VARCHAR2,
652 p_dequeue IN VARCHAR2,
653 x_msg_count OUT NOCOPY NUMBER,
654 x_return_status OUT NOCOPY VARCHAR2,
655 x_msg_data OUT NOCOPY VARCHAR2);
656
657 End IEM_PREPENQDEQ_PUB;