1 PACKAGE OE_MESSAGE_PURGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXMPRGS.pls 120.2 2005/09/29 01:48:00 pkannan noship $ */
3
4 /* ---------------------------------------------------------------
5 -- Start of Comments
6 -- API name OE_MESSAGE_PURGE_PVT
7 -- Type Private
8 -- Function
9 -- Pre-reqs
10 -- Parameters
11 -- Version Current version = 1.0
12 -- Initial version = 1.0
13 -- Notes
14 --
15 -- End of Comments
16 ------------------------------------------------------------------ */
17
18 /* -----------------------------------------------------------
19 Procedure: Purge_Messages
20 ----------------------------------------------------------- */
21 PROCEDURE PURGE(
22 errbuf OUT NOCOPY VARCHAR2
23
24 ,retcode OUT NOCOPY NUMBER
25
26 ,p_commit IN NUMBER DEFAULT 500
27 ,p_start_date IN VARCHAR2
28 ,p_end_date IN VARCHAR2
29 ,p_message_source IN VARCHAR2
30 ,p_customer_id_name IN NUMBER
31 ,p_customer_id_number IN NUMBER
32 ,p_order_type_id IN NUMBER
33 ,p_start_order_num IN NUMBER
34 ,p_end_order_num IN NUMBER
35 ,p_message_status_code IN Varchar2 Default Null);
36
37 END OE_MESSAGE_PURGE_PVT;